Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to apply Sort By Expression in Pivot Table and Sort depending upon the Alphanumeric Values like Grade A1,A2,B1,B2
I'm using Only(Grade) in Measure, Year in Column and Class and School in Dimensions Row.
Since you're sorting by the measure, you should just need to turn on "Sort by first measure" under Sorting.
Trying to implement Dynamic Sorting like this https://www.youtube.com/watch?v=iiMlRVJWmsk