Thursday, April 12, 2012 4:07 PM
I found an old answer to this same question as "Grouping is not implemented for the in-memory PowerPivot models". I'm not quite sure what this means. The row label I'm using is a calculation =value(users[1st Load]-users[Registration date]). 1st load and Registration date are both dates (not idea why I had to use VALUE to stop the error!) and this gives an output of 0 to 175 days. I want to group them 0-7, 8-14 etc.
Thanks for any advice
Friday, April 13, 2012 3:19 AM
Grouping rows can be done using Alberto Ferrari's technique for 'banding'. check out his blog entry, that explains how to implement the technique, @ http://sqlblog.com/blogs/alberto_ferrari/archive/2010/10/12/banding-with-powerpivot.aspx
- Marked As Answer by masplin Saturday, April 14, 2012 1:20 PM
Saturday, April 14, 2012 1:20 PMBrilliant.
Wednesday, March 06, 2013 11:29 PM
Brilliant??!? I used to be able to select three items in the pivot table, right click and say "Group". Now, using the solution described in this blog post, I either have to write an IF formula or create *a separate table* containing the values I want to group on and then write a formula doing a lookup into the separate table.
I'll tell you what would be brilliant - make selecting and right clicking work!