View Single Post
 
Old 03-19-2017, 08:09 AM
nanka nanka is offline Windows 8 Office 2016
Novice
 
Join Date: Mar 2017
Posts: 4
nanka is on a distinguished road
Default

Quote:
Originally Posted by nanka View Post
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
Reply With Quote