Does anyone know why a pivot table wouldn't sort correctly using an expression?
The two tables below use the same expression to sort the dimension. The straight table sorts correctly while the pivot table doesn't. The sort works on all dimensions except for one, which is the one I need to show in the pivot.
Pivot Table
Straight Table
The 'variable' in this case is from the variable extension (button)
=if($(variable)= 'All',
Sum({$<[(Y/N)] = {'Company1', 'All Others'}, [X or Y] = {'X'}, [Recent] = {'Y'}>}[Vol])
,
if($(variable)= 'All Others',
Sum(({$<[(Y/N)] = {'All Others'}, [X or Y] = {'X'}, [Recent] = {'Y'}>} [Vol])
,
Sum({$<[(Y/N)] = {'Company1'}, [X or Y] = {'X'}, [Recent] = {'Y'}>} [Vol])
))
Thank you in advance!