I've been working on creating a pivot table connected to an external SQL 2005 warehouse. I was able to add the row labels and column labels and then create a new private calculated member. However, when I select some rows of data to group them
my private calculated member disappears from the field list and from my pivot table.
When I attempt to re-add the private calculated member to the pivot table I get the following error message
"There was a problem create the calculation: Exception from HRESULT:0x800A03EC"
Am I doing something wrong or are private calculated members created by this add-in not available for groups?
Any assistance is greatly appreciated.