Getpivotdata - obtaining single line item or total with the same formula

[danaya]

Hello,

I'm building a simple excel dashboard, which I'm basing off of a large pivot table and the output is using Get Pivot command and the user parameters are passed into the get pivot command.

Here is simple example: =GETPIVOTDATA("Sales $",$A$3,"Branded","NO")

So the user would pick YES or NO for Branded through a radio buttons or something similar. My issue is that I would like one of the options to be "ALL". I can't figure out a way to do this using the same GETPIVOTDATA statement.

I searched around on the forums and their their seem to be techniques like using arrays, but I feel there is probably some native get pivotdata functionality that exists for this seeming simple task.


Thanks for you help.


Daniel

 

[RoryA]

Assuming you have a cell with the appropriate value in it, you could use something like:
=IF(F1="ALL",GETPIVOTDATA("Sales $",$A$3),GETPIVOTDATA("Sales $",$A$3,"Branded",F1))