Forum Discussion

QQQ's avatar
QQQ
Advocate II
8 years ago
Solved

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 Pow...
Need Help
  • QQQ's avatar
    QQQ
    8 years ago

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

     

    Surely there must be a workaround.

BILASolution's avatar
BILASolution
Solution Specialist
8 years ago

 

 

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.