Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!