+ Reply to Thread
Results 1 to 3 of 3

Adding levels to Pivot table Subtotal

  1. #1
    Registered User
    Join Date
    01-09-2021
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    1

    Adding levels to Pivot table Subtotal

    I have created a pivot table, using 3 column levels and 1 row level to report floor area for each institute in my university, split into 3 categories. Please see attached file with an example.

    Is there a way to add the "Area type"-level to the subtotal of the faculties and the grand total, so that I can see a break down of the total faculty and university area into the three categories?
    Attached Files Attached Files

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

    Re: Adding levels to Pivot table Subtotal

    Hello EsbenFjer and Welcome to Excel Forum.
    Perhaps producing two additional pivot tables would help in displaying the area type subtotaled by faculty as in row 20 and the overall total by area type as in row 40.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    33

    Re: Adding levels to Pivot table Subtotal

    Hi,

    i would switch the rows and column, easier to read in my view.
    By using slicer you can show the values for each selection, if thats enough
    If you want to see all of the cats at once, you need to make a second pivot i guess
    Attached Files Attached Files

+ 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. Different formats for different levels of a pivot table
    By stephme55 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-15-2016, 01:17 AM
  2. DISPLAY SUBTOTAL and SUBTOTAL % in PIVOT TABLE
    By excelmr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2015, 05:44 AM
  3. Adding addtional Subtotal to Pivot Table
    By Jack106 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-28-2014, 07:59 AM
  4. sorting pivot table in levels
    By RubiksCuber in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-27-2013, 07:05 PM
  5. Replies: 1
    Last Post: 12-23-2010, 08:44 AM
  6. Replies: 12
    Last Post: 05-15-2010, 03:02 AM
  7. Pivot Table Hide Levels in VBA
    By Brett in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2005, 12:05 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