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!

[ingoniclas]

Nope.

[sunny_talwar]

How about this?

Sum({<Product>}sales) + Sum({1} 0)

[ingoniclas]

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)