How can I sort only my visualization without actually sorting the data?

[Brandon_Ihrig]

High level, I’ve created a bar chart based on table calculations and these table calculations are dependent upon how my dimensions are being sorted. However, I’m then needing to sort my actual visualization by a different measure within my data. How would I go about sorting my chart (high to low) without affecting the actual underlying data?

[Dawid]

Unfortunately the visualisation’s sorting is directly tied to the sorting of the data tab result columns.. Just out of curiosity, why would you need your data table to be sorted in one way and visualisation in another?

[Brandon_Ihrig]

Hey Dawid, thanks for the reply. So my data is already being priority sorted on two dimension’s because I’m trying to create a week-over-week percentage change calculation via the offset function. If I sort my actual data in any other way my results won’t be correct.