If you actually have a pivot table (unlike your sample!) then GETPIVOTDATA may well do what you need