Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
That is really sad. Combined two tables to extend the data and now I cannot group.
Surely there must be a workaround.
Hi,
As far as i know, the Grouping featue is deactivated on Pivot Tables created via the Data Model.
That is really sad. Combined two tables to extend the data and now I cannot group.
Surely there must be a workaround.
@QQQ wrote:
That is really sad. Combined two tables to extend the data and now I cannot group.
Surely there must be a workaround.
For better response, I'd suggest you post in the dedicated Power Pivot Forum. There're more experts there.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |