Sorting the Dimension in Pivot Table

Tue, 07 Apr 2015 15:26:07 GMT

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

Re: Sorting the Dimension in Pivot Table

Anonymous — Tue, 07 Apr 2015 18:56:00 GMT

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'))