Sorting the Dimension in Pivot Table

[#1]

Hi team,

Please help me in sorting the Dimension.Fiscal Year should start with Nov as first Month.

The sorting expression which is used is not working .

For your reference attaching the sample qvw file.

After FY14 Jul    FY14 Aug and following should come but its not coming correctly.

Thanks in Advance.

Sreehari Satheesan

[Anonymous · Accepted solution]

This works:

=dual(Month,mid(Month,3,2) & num(match(right(Month,3),'Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct'),'00'))