Grand total issue when selecting current period.

Manish ! 1 Reputation point
2021-10-05T11:33:33.017+00:00

Hi,

After processing multidimensional cube the data exported to the 'Excel pivot'. In that pivot when selecting the [time calculation][Current period] the unique month is showing the total 10 years count. But I'm filtering only current year 8 months.

Below is the calculation

Scope([Time Calculation].[Current Period],[String].[String Hierarchy].allmembers, [Key Figure].[Key Figure Long Name].allmembers);
THIS = (Measures.currentMember,[Time Accounting Period].[Accounting Month Hierarchy].currentMember);
End Scope;

Example

2011 2012 2013 2014 2015 Grand total
10 20 10 30 40 110

My Issue when filtering
2011 2014 2015 Grand total
10 30 40 110

But the Grand total is '80'

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
124 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.