Hi rorya,
That worked - thank you. I actually tried this method before posting, but it wasn't working at the time - which made me question whether it worked with OLAP pivots. It turns out that I had broken my pivot connection which is why GETPIVOTDATA didn't work.
For sake of convenience for others searching, GETPIVOTDATA syntax with OLAP does differ a bit in that it appears to use an in-built "Measures" class and an object link to the table:
My pivot has a "Grand Total" row at bottom, but the reference to "[Measures]" is apparently invoking a method of the table object. Now I'm curious what other methods might be available to GETPIVOTDATA in this manner.
Bookmarks