question

Manish-1287 avatar image
0 Votes"
Manish-1287 asked Manish-1287 commented

Grand total issue when selecting current period.

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'

azure-sap
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

We would need further details to understand the issue better. Can you please share which Azure products/services are you using, your scenario and issue in detail as well as end goal. Thanks.

0 Votes 0 ·
Manish-1287 avatar image Manish-1287 karishmatiwari-msft ·

Hi Karishma,

I'm using Microsoft visual studio Community 2017 for Cube development(Version 15.9.34).

My issue is Cube data in excel is showing wrong 'Grand total' when selecting Unique month column from pivot.

Actually the grand total value is displaying whole sheet sum. Instead of showing selected sum. 138135-screenshot-2021-10-06-16-15-21-829-comwhatsapp.jpg


0 Votes 0 ·

0 Answers