Custom Sort (Cycle) Dimension

[Anonymous]

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

[Gysbert_Wassenaar]

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

[Anonymous]

Hi Gysbert,

Option 1 worked fine, thanks.

But can you explain option 1 a bit further how the solution should work?