I want my chart sorted on the difference between two years. I know that is (in my case) only possible when the chart is a straight table.
Now I want the user give the option to switch between a pivot table and a straight table. When I enable those under General->Fast type change the option to demote/promote sorting values disappears.
Is there another option to achieve my goal. I don't like to have two charts with the same dimensions and expression just to have a different sorting option.
Sorting by the Y-value is not possible either because it is not the first expression.
