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.