Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to change the order of the columns in a pivot table. Right now the order is like this with the "Region" dimension:
Europe | Emerging Markets | Asia | North America |
How can I change it to this:
North America | Europe | Emerging Markets | Asia |
I tried to create a sort expression with a match function and another one with the dual function. Both didn't work.
Thanks!
Regards
Samuel
This one worked for me:
Match([NAME OF DIMENSION IN ROW PIVOTTABLE], Dual('North America',1), Dual('Europe',2), Dual('Emerging Markets',3), Dual('Asia',4))
This one worked for me:
Match([NAME OF DIMENSION IN ROW PIVOTTABLE], Dual('North America',1), Dual('Europe',2), Dual('Emerging Markets',3), Dual('Asia',4))
Thanks it works! 🙂