cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Cannot group fields in Pivot Tables

Software: MS Excel 2016

Excel File: GitHub Repository

 

____________

 

I am unable to group fields in pivot table of Excel file.

 

Graffiti table is linked with Calendar table via Date (in PowerPivot > Data Model), so why is there difficulty in grouping the following.

 

However if I unlink the tables (which is what I DO NOT want to do), then it works

 

enter image description here

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

That is really sad.  Combined two tables to extend the data and now I cannot group.

 

Surely there must be a workaround.

View solution in original post

5 REPLIES 5
Highlighted
Solution Specialist
Solution Specialist

Group.png

 

 

Hi, whenever you group some rows, excel creates a parent - child hierarchy (See the picture above). In your case the problem appears because of a new included value in the parent field (Group 1). This value isn't related with the Date Table then the error message pops up when you try to do the grouping.

 

Highlighted
Super User III
Super User III

Hi,

 

As far as i know, the Grouping featue is deactivated on Pivot Tables created via the Data Model.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Solution Specialist
Solution Specialist

@Ashish_Mathuris right. I tried to find out a cause for solving the problem.

 

Highlighted

That is really sad.  Combined two tables to extend the data and now I cannot group.

 

Surely there must be a workaround.

View solution in original post

Highlighted


@QQQ wrote:

That is really sad.  Combined two tables to extend the data and now I cannot group.

 

Surely there must be a workaround.


@QQQ

For better response, I'd suggest you post in the dedicated Power Pivot Forum. There're more experts there.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors