How to achieve only Selected metrics from from Value prompt to be displayed

[tarunkrdas2013]

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

[sdf]

have you tried using a filter or a slicer?

[tarunkrdas2013]

will try and let you know

[tarunkrdas2013]

No success with filter and slicer as well,attached report xml if you can suggest something

[sdf]

please try

if ( ?p_Metrics? = 'TY Sales'  and  ?p_ReportType?='DATE')

for all conditions.

[tarunkrdas2013]

Thanks SDF it worked