Notifications
Clear all
Power Pivot
4
Posts
2
Users
0
Reactions
11
Views
Topic starter
I want to add new group or zone in my pivot table to Sum date wise quantity. File is attached. Plz give me the solution
Thanx
Posted : 26/09/2019 8:38 am
Hi Nadeem,
Can you try uploading your file again, please. It appears something went wrong as I can't open it.
That said, if you want to add a new group or zone then this data should be in the source file. i.e. a column for the Group that categorizes each row into it's respective group. Or if you're using dimension tables, you may be able to categorize a dimension into the respective Group.
Mynda
Posted : 26/09/2019 7:36 pm
Topic starter
File is attached again
Posted : 27/09/2019 1:10 am
Hi Nadeem,
Thanks for sharing your file. It can't be done. You'd need to create a separate PivotTable and remove the Zone field to get the figures for 'All' split by date.
Mynda
Posted : 27/09/2019 2:46 am
