Unable to group rows in pivot table created from PowerPivot data

Question

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

Mike

Answer 1

Hi Mike

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

---

Javier Guillen
http://javierguillen.wordpress.com/

Answer 2

Brilliant.

Answer 3

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!