I have DMR cross tab report with static values from Value prompt as TY sales,LY sales.
Problem is when i run report all measures are displayed whereas i want only selected metrics
to be displayed in cross tab.
My Report expression is
if ('TY Sales' in ?p_Metrics? and 'DATE' in ?p_ReportType?)
then (
tuple([Hierarchical].[Sales].[TY Member Net Sales Amount], [DAILY])
)
else
(if ('TY Sales' in ?p_Metrics? and 'WEEK' in ?p_ReportType?)
then (
tuple([Hierarchical].[Sales].[TY Member Net Sales Amount], [WTD])
)
else
(if ('TY Sales' in ?p_Metrics? and 'PERIOD' in ?p_ReportType?)
then (
tuple([Hierarchical].[Sales].[TY Member Net Sales Amount], [PTD])
)
else
(
tuple([Hierarchical].[Sales].[TY Member Net Sales Amount], [YTD])
)
)
)
Can anyone please let me know about this
have you tried using a filter or a slicer?
will try and let you know
No success with filter and slicer as well,attached report xml if you can suggest something
please try
if ( ?p_Metrics? = 'TY Sales' and ?p_ReportType?='DATE')
for all conditions.
Thanks SDF it worked