Hi Dee
The simple answer is yes, this formula is somewhat unrelated to your example but you'll get the point.
In this instance I'm getting the Net Sales for a Sales Person who is being found on another sheet via the VLookup.
=GETPIVOTDATA("Net Sales",$P$15,"Sales...