Pivot table - change order of columns

[SamuelHaag]

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

[Kirsten · Accepted solution]

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))

[SamuelHaag]

Thanks it works! 🙂