Quote:
Originally Posted by nanka
Hi,
I am showing the %row total of certain categories per week in the pivot table. The source is a query table. When i am clicking insert I create the pivot table by checking in a data model.
My goal is to have the total count of categories per week right next to the %s. Fort that I tried dragging po field in the pivot column field list. the same data column into the pivot table values field - but instead of just showing me the total count per week it's also showing count of each category.
How can I just only add the total count of categories as a second field to get the view mentioned above?
Your help is much appreciated!
Thanks
nanka
|
I have posted the same question in other forums as well. To comply with the forum rules and not waste your time i am including the links.
Below are the links where the same question is posted.
https://www.mrexcel.com/forum/excel-...ml#post4781987
https://www.excelforum.com/excel-gen...ml#post4586974
https://www.msofficeforums.com/excel...tml#post112517
https://social.msdn.microsoft.com/Fo...f-bb8eb7f5525d
http://www.excelbanter.com/showthrea...46#post1628546