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