Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Grand Total – Total

Answered
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.
 
Thanks
Nagaraj

1 answer

Public
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.
Regards,
Dmytro

Please login or Register to Submit Answer