+ Reply to Thread
Results 1 to 2 of 2

(Sub)Total for Columns in Pivot Table

  1. #1
    Registered User
    Join Date
    09-07-2017
    Location
    Toronto, Canada
    MS-Off Ver
    2016
    Posts
    1

    (Sub)Total for Columns in Pivot Table

    Hi there,

    I am guessing I know the answer to this question ("No"), but I thought I would put it out there as a last resort.

    I am using Excel 2016 and I have a Pivot Table that calculates the number of participants, by gender, per month that each Community reached. Each Community has its own assigned Manager and Coach. I would like to keep my table set up how it is (see attached example), but I am looking for a way to total the number of participants of each gender reached for each month (among ALL Communities) somewhere within my Pivot Table. Ideally, this would be at the bottom of the table, perhaps as a list of the months and the totals for each column.

    Essentially, I want my Pivot Table to be able to answer the following question for each gender: How many girls were reached in September across all Communities?

    Is there a way to do something like this?

    Thank you in advance!
    Attached Files Attached Files
    Last edited by MandEQueen; 10-23-2020 at 02:27 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,085

    Re: (Sub)Total for Columns in Pivot Table

    Hello MandEQueen and Welcome to Excel Forum.
    Unfortunately I do not believe that a pivot table will display in the manner you are describing.
    It is probably trivial to say that you could produce another pivot table that would show totals by gender per month by:
    Placing Months in the Rows area
    Placing Sum of Number of girl participants, Sum of Number of boy participants and Sum of Number of gender non-binary participants in the Values area.
    Sorry not to be of more help.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table - Grand Total for Rows
    By aquaremo in forum Excel General
    Replies: 1
    Last Post: 07-13-2016, 08:36 AM
  2. [SOLVED] Get first 5 rows from pivot table and grand total of overall data
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2016, 01:42 PM
  3. Excel Pivot table - to show the total on rows not working?
    By eiffel99 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-28-2015, 12:52 PM
  4. pivot table total rows
    By tigertim71 in forum Excel General
    Replies: 4
    Last Post: 07-22-2008, 06:12 AM
  5. Pivot Table total rows hide?
    By EnergyEngineer in forum Excel General
    Replies: 3
    Last Post: 04-29-2008, 02:56 PM
  6. Pivot Table - Grand Total for Rows
    By Joe in forum Excel General
    Replies: 3
    Last Post: 05-30-2006, 07:10 PM
  7. Highlighting total rows in pivot table
    By jim37055 in forum Excel General
    Replies: 4
    Last Post: 12-15-2005, 01:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1