I have a challange for you. I have a market dataset with different brands and each brands has different products. Some products are ours, other are not. There is a brand that has two products of my company.
I would like a pivot table with products (and brands if needed) as dimension and the sum of volume for each brand as expression; I also would like it dispite selections on brands or products..
Please see the excel attached for details.
BTW I simplified it a bit, just consider I also have to use set Analysis in the sum (like {$<MeasureType={'ITM'}, DYear={$(CurrY)},...).