Extensions not working when data is grouped

Topics: Resolved
Sep 3, 2009 at 7:30 PM

Hello,

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.

Coordinator
Sep 3, 2009 at 8:12 PM

Unfortunately that's a bug in Excel, not in OLAP PivotTable Extensions. See this thread:

http://olappivottableextend.codeplex.com/Thread/View.aspx?ThreadId=45104
and
http://olappivottableextend.codeplex.com/WorkItem/View.aspx?WorkItemId=12807

I would report to Microsoft. I've heard people haven't had great success convincing them it's a bug in Excel, but keep trying, because it definitely is.

Marked as answer by furmangg on 6/10/2014 at 3:48 PM