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.
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.