Cannot Group pivot made from Data Model

Hello,

On Sheet2 I have created a pivot table based off a Data Model relationship. When I try to GROUP my table into bins of 25 rows (as I did in Sheet1) the GROUP menu item is greyed out. I am really hoping this is simply my inadequate Excel skill rather than a lack of Excel functionality.. Group Pivot made on Data Model relationship.xlsm

QUESTION: Could anyone please tell me how to get the "Group" functionality working for a pivot table based off a Data Model relationshihp?

So very worried I won't be able to do this..
Thanks again,
Michelle

There is some problem due to changing XL versions.
Try to create new PT again.

Hello gentlemen thank-you for your replies - - -however I have Excel 2013 and created this sheet from scratch using Excel 2013.

If you open my attached spreadsheet are you able to "Group" the pivot on Sheet2?

Originally Posted by Pepe Le Mokko

Well grouping won't work in earlier versions . Can you save it in an earlier version? ( I don't know 2013 at all I'm afraid)

Hi Pepe - do you mean to say that only version 2013 has the GROUP BY functionality for pivot tables? If this is the case then I'm not sure why you are asking me to save to an earlier version. Regardless, when I do try to do this for you the only choice I seem to have is Excel 1997 -- and I get many warnings/error messages of incompatible functionality.

SAVE_AS_FORMAT.png

I was also able to get around this by adding a conditional column in my query in the data model.