A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Adding the same field in the column field list of pivot table

Thread Tools Display Modes
Old March 19th 17, 03:17 AM
nanka nanka is offline
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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 08:22 PM
Adding two field into Pivot Table IF Statement[_2_] Excel Discussion (Misc queries) 0 November 21st 07 05:12 PM
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 29th 07 11:13 PM
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:03 AM.

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