Hi guys,
I am using leaf members of 3 hirrarchies(Product,brand and market) in the prompt page using the following function:
filter( members ([Profitability Report].[Products] ),
count(1 within set children(currentMember([Profitability Report].[Products] ) ) ) = 0 )
Now in my report query i need to use product, brand and market chosen on the prompt page to slice or filter my data on crosstab.
How do I use a slicer/context filter to get correct data?
I have tried using a data item similar to prompt query using the following funtion:
Product leaf Memeber=filter( members ([Profitability Report].[Products] ),
count(1 within set children(currentMember([Profitability Report].[Products] ) ) ) = 0 )
and used this in slicer with formula Product leaf memebers in ?Products?
But when I add another 2 slicers for brand and market, it shows me "-" dashes on the report output