🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Grand Total – Total

Nagaraj Chatiri asked on January 4, 2020

Hi Team, 
There are some calculated measures in our cube, for example, “Total Amount” that is equal to (“Invoice Amount” + “Taxes”), when we select grand total option in the flexmonster then grand total for “Invoice Amount” and “Taxes” gets displayed but does not display for “Total Amount”, please suggest how grand total of “Total Amount” can be displayed.

1 answer

Dmytro Zvazhii Dmytro Zvazhii Flexmonster January 8, 2020

Hello Nagaraj,
Thank you for your question.
When working with SSAS cube, Flexmonster generates the data queries and sends them to the cube. The received data is displayed in the Pivot Table. 
It seems that the necessary "Total Amount" data is not returned from the cube. That is why it is not displayed.
Could you please provide us with the small dump of your cube where the issue is reproducible? It will help us a lot in our further investigation.

Please login or Register to Submit Answer