R
RichardO
Hello everyone,
Hope you had a great weekend.
I have a getpivotdata question. I have a pivot table with "State" i
the Row field and "due" in the data field and "Timing" in the colum
field.
I have a summary report in another sheet that I have designed so tha
it would get the data from the pivot table and this summary changes a
the data changes.
In my summary report I have 3 columns altogether, 1 column each for
states (Approval and Blank) that occur 100% of the time. Sometimes,
other states could occur (Review, First level and Buff, sometimes i
could just be 2 of these or just 1 additional state that will occur.
So, in the 3rd column, I can't put in a get pivot data formula becaus
I don't know which states are in the data except I go through the data
Is there a way that I could write a getpivotdata formula that will ge
the remaining data other than the 2 states that occur 100% of the time
I tried putting in all the three states in the 3rd column but I get
#REF message because sometimes not all these states are in the data
find my formula as follows:
=GETPIVOTDATA("Sum o
Due",PTs!B42,"State","Review","Jeopardy","Yes")+GETPIVOTDATA("Sum o
Due",PTs!B42,"State","First level","Jeopardy","Yes")+GETPIVOTDATA("Su
of Due",PTs!B42,"State","Buff","Jeopardy","Yes")
Thanks for your help.
RichardO
Hope you had a great weekend.
I have a getpivotdata question. I have a pivot table with "State" i
the Row field and "due" in the data field and "Timing" in the colum
field.
I have a summary report in another sheet that I have designed so tha
it would get the data from the pivot table and this summary changes a
the data changes.
In my summary report I have 3 columns altogether, 1 column each for
states (Approval and Blank) that occur 100% of the time. Sometimes,
other states could occur (Review, First level and Buff, sometimes i
could just be 2 of these or just 1 additional state that will occur.
So, in the 3rd column, I can't put in a get pivot data formula becaus
I don't know which states are in the data except I go through the data
Is there a way that I could write a getpivotdata formula that will ge
the remaining data other than the 2 states that occur 100% of the time
I tried putting in all the three states in the 3rd column but I get
#REF message because sometimes not all these states are in the data
find my formula as follows:
=GETPIVOTDATA("Sum o
Due",PTs!B42,"State","Review","Jeopardy","Yes")+GETPIVOTDATA("Sum o
Due",PTs!B42,"State","First level","Jeopardy","Yes")+GETPIVOTDATA("Su
of Due",PTs!B42,"State","Buff","Jeopardy","Yes")
Thanks for your help.
RichardO