topic Re: Cannot group fields in Pivot Tables in Desktop

Cannot group fields in Pivot Tables

QQQ — Mon, 09 Oct 2017 23:24:52 GMT

Software: MS Excel 2016

____________

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

Re: Cannot group fields in Pivot Tables

BILASolution — Tue, 10 Oct 2017 00:17:13 GMT

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.

Re: Cannot group fields in Pivot Tables

Ashish_Mathur — Tue, 10 Oct 2017 00:30:34 GMT

Hi,

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

Re: Cannot group fields in Pivot Tables

BILASolution — Tue, 10 Oct 2017 01:33:18 GMT

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

Re: Cannot group fields in Pivot Tables

QQQ — Tue, 10 Oct 2017 17:31:05 GMT

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

Surely there must be a workaround.

Re: Cannot group fields in Pivot Tables

Eric_Zhang — Fri, 13 Oct 2017 02:28:29 GMT

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.