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!
tried this?
sum({$<MonthYear=>}Sales)
or this
Sum(TOTAL <MonthYear> Value)
May be this
Sum(sales) + Sum({1} 0)
Nope, none of this works. However, I forgot to mention that product and MonthYear are inked with a combined key in the data model. So I wonder if there is a solution like I am looking for at all.
Are you looking to ignore selection in Product field? May be this
Sum({<Product>}sales)
This works in the way that the MonthYear dimension is static, however, it cuts away all the sales prior to the first month where product and MonthYear are linked 😞
I think you are looking for this
Sum({<Product>}sales)
Check this out.
Note : manipulate the color of the line(make it white) ! for the 'Not Active' Product, in case you want to see the line only for the selected product,