# Sum of two column labels in pivot table

1. ## 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'

2. ## Re: Sum of two column labels in pivot table

Use Slicer

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

3. ## 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!

4. ## 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. ## 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. ## 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. ## 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. ## Re: Sum of two column labels in pivot table

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

9. ## Re: Sum of two column labels in pivot table

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

#### 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