Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table with three dimensions and an expressions. Each dimension has a different sorting. The first and second dimension if working correctly but the third one is not sorting correctly. I have attached sample file here.
Thanks for your help.
Like this:
No, Block Name should be sorted using column Course Sort, Exam Group should be sorted using ExamDate and Exam Name shouls be sorted using SortID
Like this:
Thanks,
Hopefully, got this right this time.
No, if you see the second Exam Group 'Written 2' the sort order is wrong.
I have tried so many different things here but the sorting is not working for Exam Names.
This way?
The Correct Sort Order is this: I did this in excel.
Thanks