Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a chart showing sales per product along a time axis, see below. It has the following dimensions and expressions:
1st Dimension: MonthYear
2nd Dimension: Product
Expression: sum(sales)
Now I want the 1st dimension 'MonthYear' to be ignored when I select a product that is linked to MonthYear in the data model. I have tried to use a set analysis as expression, but I couldn't make it work. Any help would be appreciated. Many thanks!
Nope.
How about this?
Sum({<Product>}sales) + Sum({1} 0)
That's it! A great general scheme for these kind of challenges! Thanks Raju and everyone else for their help!
For all those interested: I used the following expression and it worked:
sum({$<[$(=Concat({1<$Field-={'MonthYear'}>}distinct $Field,']=,[')&']=')>} Sales)