LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 19th 17, 04:17 AM
Junior Member
First recorded activity by ExcelBanter: Mar 2017
Posts: 1
Default Adding the same field in the column field list of pivot table


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!


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove a Calculated Field from the Pivot Table field list TheTraveler Excel Discussion (Misc queries) 2 April 9th 10 06:55 PM
Adding a calculated field to a pivot table DanL Excel Worksheet Functions 4 March 9th 08 09:22 PM
Adding two field into Pivot Table IF Statement[_2_] Excel Discussion (Misc queries) 0 November 21st 07 06:12 PM
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 30th 07 12:13 AM
Pivot Table - adding a new field Pivot Table Excel Discussion (Misc queries) 2 June 9th 05 07:46 PM

All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017