Ignoring 1st Dimension in a chart

[ingoniclas]

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!

[Chanty4u]

tried this?

sum({$<MonthYear=>}Sales)

[Chanty4u]

or this

Sum(TOTAL <MonthYear> Value)

[sunny_talwar]

May be this

Sum(sales) + Sum({1} 0)

[ingoniclas]

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.

[sunny_talwar]

Are you looking to ignore selection in Product field? May be this

Sum({<Product>}sales)

[qv_testing · Accepted solution]

Ignore all selections except some specific fields using Set Analysis

[ingoniclas]

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 😞

[sunny_talwar]

I think you are looking for this

Sum({<Product>}sales)

[krishna_2644]

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,