Hi there,

I need to retrive data from a pivot table that is not from an OLAP source. I
need to get the data for a item and then also display that data for the
parent of that item. Basically they want to see sales for a particular
product and then the sales of that product group. There are hundreds of
products so I need to be able to lookup its parent from the pivot table. Once
I have the parent I can retrieve data using getPivotData.

However I just get the message ""Unable to get the ParentItem property of
the PivotItem"

It says something similar if I try to get the ChildItems collection.

Any help is appreciated.