Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
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