values in dimension disregarding selections

[#1]

Hey,

I have three fields (ID, product, sales). One of them I use as a dimension (product) and one as an expression (sales) in a chart.

I want that dimension (product) shows only values, that depend on selections in ID field and do not depend on any selections in product field.   

In this case: when I select 001 in ID and cookie in product field, I want to see in product dimension cookie and pie (and not only cookie!).

I suppose it should be solved with set analysis, but I need help.

Many thanks

[sunny_talwar]

May be try this

=Sum({<product>}sales)

[#3]

Thank you Sunny!