Sorting in Pivot Table

egoss_cynosure_ — Sat, 16 Nov 2024 06:42:26 GMT

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 TableStraight 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!

topic Sorting in Pivot Table in App Development

Sorting in Pivot Table