Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an pivot table with a dimension which a want to sort on custom order,
Let say's Dimension 1 with Fields
A
B
C
D
E
But I want to sort by the following order:
B
D
E
A
C
How do i realize this? With an Inline script and an Expression?
Thanks
Robert
You can determine a sort order by first loading the values in the script in the order you want them in a temporary table. You can then sort by Load Order. Or you can sort by expression: match(only({1}[Dimension 1]), 'B','D','E','A','C')
Hi Gysbert,
Option 1 worked fine, thanks.
But can you explain option 1 a bit further how the solution should work?