sense scatter chart measure sorting - cummulative measure
I have some trouble with scatter chart showing ABC-XYZ percents by some dimension (say goods group).
First, I have created simple table with goods group as a dimension and Sales Amount as descending measure. I calculate cummulative sales total and cummulative sales percent for ABC rank. It is simple and it works:
In my scatter chart i have to use ABC percent on X-axis and XYZ variation coef on Y-axis. I tried using same expression as above for "measure 1", but i clearly saw that Scatter does not sort data as Table. As a result i have incorrect data in scatter chart.
I could not find any possibility to sort through some scatter chart property.
Is there any workaround how to make scatter chart work properly?