Sorting Issue

[Anonymous]

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.

[sinanozdemir]

Like this:

[Anonymous]

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,

[sinanozdemir]

Hopefully, got this right this time.

[Anonymous]

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.

[Qrishna]

This way?

[Anonymous]

The Correct Sort Order is this: I did this in excel.

Thanks