New Column Calculate Pivot Table

ghumphrey

New Member
Joined
Oct 13, 2011
Messages
11
First time poster and despite plenty of research on google, couldn't come up with an answer(afraid my solution may not be feasable).

I have data that I am summarizing with a pivot table:

ID SubID Type
1 1 A
1 2 A
1 3 B
2 1 C
3 4 A

etc.

In the pivot table I have the following:

Rows
ID
Sub ID

Column
Type (which has A, B, C)

It shows up as follows:
a b c
1
1 1
2 1
3 1
2
1 1
3
4 1

A SubID may have more than one type (both quantity of the same and quantity of different types).

By it's nature though, I need to filter down to see only those SubIDs that have a value for C AND do NOT have a value for A and B.

At the moment my data is small enough that I can just copy my pivot table to another tab and write the following : {=and(A4<>0,A2:A3=0)} to get my result (T/F) to sort which ones fall within, both the ID and the SubID live in my first row of data and I need to process that data further.

My goal would be to create a new column WITHIN the pivot table that does the exact function that I am asking for, that was I can filter within the pivot table and reorganize or add more data to my pivot table to best present my numbers. Does anyone have any idea on how to add this column to the pivot table?

Thanks for your help!
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top