Hi,
I have a little and maybe wellknown problem retrieving data from my pivot table on which I didn't apply any output summary; My pivottable is just a column with 3 row levels (i.e. i have 3 fields dragged into the area "Row Labels").
When I use the getpivotdata function i'm getting #REF and i'm sure i'm using it correct. I want to retrieve the 3rd row level by looking up 2nd row level. Something makes me believe that getpivotdata function is not helpful for this. My pivottable is actually an SQL-query with a query-name.
Bookmarks