1 of 1 people found this helpful
In your example, if you remove storeRef dimension, does Customer Ref Number 2615940 totals higher than Customer Ref Number 1995072?
I bet that Ref Number 2615940 has a higher overall total. Therefore, it shows above 1995072 after you add storeRef dimension.
This is correct. If I remove storeref, 2615940 has a higher purchase total across all stores.
I ended up doing what's outlined in this comment in another thread: Re: Sort buttons in chart not working correctly
Wondering if there's a simpler or different way to do this though.
You could add another discrete column to the left of the Cust Ref Number to drive the sort. Easiest thing would be to use SUM(Total).
Ctrl-click on the green SUM(total) pill in the Columns shelf and drag it to the Rows Shelf. Click the pill and select Discrete. Then move it to the left of the blue, discrete Cust Ref Number. Click on the SUM(total) pill and then click the Sort Icon on the toolbar. Finally hide the column by clicking the pill and deselecting Show Header.
Sorry just tried this and it seems a bit finicky. For example, if you click the X axis and hit the sort icon, it sorts everything ascending and you're stuck until you click the discrete pill again and click the descending icon.
It might be safer to use convert the SUM(total) pill to a rank table calculation (assuming you have Tab 8.1; if you don't you could use index(), but it's a couple of extra steps). This appears to override any user-selected sort from the axis. I did this by right-clicking SUM(total) > Quick Table Calculation > Rank. Click again > Compute Using > Custom Ref Num.
This will also make it easier to apply a filter like Top 5 by filtering on the rank column.