Sorting A Column Of PowerPivot Data By Another Column

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

One of the things that used to drive me crazy about working with PivotTables in PowerPivot's initial (2008) release was summarizing dates by month. With a standard PivotTable, we can use the built in Group functionality to group dates by Years, Quarters and Months. But in PowerPivot, that functionality wasn't implemented. To deal with this, we have to provide our own date table, but the months never really sorted well, and we had to resort to tricks to coerce them into the right order.

Read more...

Tags: design

 

2007-2015 VidasSoft Systems Inc.