+ Reply to Thread
Results 1 to 9 of 9

Sum of two column labels in pivot table

  1. #1
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Sum of two column labels in pivot table

    Folks,

    Now, I'm aware of 'Calculated Field' and 'Calculated Item' in pivot tables, but what's the way to go when you need to sum two (out of four..say!) column labels as a calculated field?

    See attached. In the pivot table I want a calculate which will sum just Q1+Q2 or Q1+Q3

    I get the error saying 'PT formulas can only refer to items in the same field as the calculated item'
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Sum of two column labels in pivot table

    Use Slicer

    (usuall Ctrl+click or Shift+click combination for multiple items)
    Attached Files Attached Files

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Sum of two column labels in pivot table

    Thanks zbor, I did think of slicers but that limits the view to just one selected option at a time. In the absence of an alternative feasible solution, that might be the way to go!

    Thanks for your input.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Sum of two column labels in pivot table

    Well, you can always create separate calculations in the original table and add it to the PT as column

  5. #5
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Sum of two column labels in pivot table

    Yep, that was my very initial thought, but wanted to explore if it was possible within the PT itself.

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Sum of two column labels in pivot table

    I know what you mean.
    It should be simple to have option to make calculations with active rows within PT.

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,213

    Re: Sum of two column labels in pivot table

    Can't you just group them in your pivot table? Then you can subtotal the group

  8. #8
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Sum of two column labels in pivot table

    Thanks Kyle, that's useful. Wonder why I didn't think of that

  9. #9
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,213

    Re: Sum of two column labels in pivot table

    Glad it helped

+ 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. [SOLVED] How to add column labels in pivot table
    By busygurl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-03-2015, 11:00 PM
  2. How to make evolutions in pivot table with multiple column labels
    By elmister in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-26-2015, 10:36 AM
  3. [SOLVED] Need to sort pivot table's column labels by type
    By adelkam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2015, 03:27 AM
  4. Pivot Table Row and Column Labels
    By srizki in forum Excel General
    Replies: 0
    Last Post: 11-06-2014, 04:38 PM
  5. Control Pivot table Column labels by cell reference
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2014, 06:00 AM
  6. Pivot Table - Show Row labels horizontally (Not as Column labels)
    By Catsup in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-16-2014, 01:15 PM
  7. Replies: 0
    Last Post: 07-03-2012, 11:09 AM

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