Dynamic filters

[#1]

Hello all,

I want to make a filter depending of the value of a dimension. To be more clear, I want to create table with Publishers in dimension and the sum of  sales in expression. But for certain publishers, I want only the sales of books, for another only for the videogame, for another one, the books and videogames.

Could you help me on this?

Thank you ,

[sunny_talwar · Accepted solution]

You can use set analysis for doing this:

Sum({<Publisher = {1}, Product = {'Books'}>+<Publisher = {2}, Product = {'VideoGames'}>+<Publisher = {3}, Product = {'Books', 'VideoGame'}>}Sales)

[#3]

Thank you verry much Sunny it's working