Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a pivottable with 2 dimensions I have sorted the first dimension by using a variable but the second dimension remains unsorted. See attachment
Video of how I created the sort of the first dimension is here and some explanation in the attachment as well
https://www.youtube.com/watch?v=iiMlRVJWmsk
If there is a better/different way to sort is also fine
Hi @Kirsten
I think it sorts by the second dimension in total.
If you want it to sort by one ProductGroup you need to filter (drill down) by that ProductGroup
Or do this. NB I haven't used it as it looks complex. (I just filter by the require ProductGroup)
This video shows how to sort by the Product within each ProductGroup
https://www.youtube.com/watch?v=PfPz_JOH1XE