Sorting multiple dimensions simultaneously in pivot table

[vinod1992]

Hi All,

I am facing a problem with sorting in pivot table i.e. when I am placing 2 dimensions with a measure I am able to achieve the sorting. But when I add the 3rd dimension I couldn't able to achieve the sorting in the pivot table. So, please help me out in this issue.

Thanks & Regards,

Vinod

[rajeshqvd]

Use Match function in sorting  like below

 =Match(Field1,'a','c,'b')