Ordering Months in PowerPivot Pivot table
User Rating: / 0
PoorBest 
Written by Gopal G   
Tuesday, 19 April 2011 20:28

This is a common requirement for business users to sort months in order(Jan, Feb, Mar...Dec), but PowerPivot is not smart enough to do automatically. PowerPivot pivot tables by default showing the months in alphabetic sequence, so when ever the user user open pivot table and drag and drop the months on row category it would appear as shown below.

Read more...

  Tags: design, excel
 

Varigence Vivid