Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ,
You can use set analysis for doing this:
Sum({<Publisher = {1}, Product = {'Books'}>+<Publisher = {2}, Product = {'VideoGames'}>+<Publisher = {3}, Product = {'Books', 'VideoGame'}>}Sales)
You can use set analysis for doing this:
Sum({<Publisher = {1}, Product = {'Books'}>+<Publisher = {2}, Product = {'VideoGames'}>+<Publisher = {3}, Product = {'Books', 'VideoGame'}>}Sales)
Thank you verry much Sunny it's working