Ordering Months in PowerPivot Pivot table

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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: excel, design

 

2007-2015 VidasSoft Systems Inc.