Calculated Total (member) regardless the pivot filter

Sep 1, 2011 at 8:49 PM

I have a PivotTable with some fields in Page area. One of those is filtered to specific month.

I want to create a caculated memeberincluding all motnhs.

I tried this name: [Parent].[Dim].[All].[AllMonths]

With this formula: ([Measures].[Amount],[Time].[Month].[All]

but nothing happens to the pivottable.

In summary, I need to refer pivottable totals inside a calculated memeber.

Thanks for help.

JCA

Coordinator
Sep 1, 2011 at 10:32 PM

If you're needing help with OLAP PivotTable Extensions, then this is the right forum. But if you're just needing generic MDX help (which is what it sounds like) then please use the Analysis Services Forum:

http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/

Make sure you specify the full MDX query of the PivotTable and describe what you expect the final PivotTable to look like once you add your calculation. Once they've helped you with the MDX you can probably add those calculations through OLAP PivotTable Extensions easily.

Marked as answer by furmangg on 6/10/2014 at 3:44 AM