Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding the same field in the column field list of pivot table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
Adding a calculated field to a pivot table | Excel Worksheet Functions | |||
Adding two field into Pivot Table | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Pivot Table - adding a new field | Excel Discussion (Misc queries) |