Get Free Trial

How to change the grand total value from UI?

Ravi asked on May 12, 2020

Hi, If i switch on a Grand Total, the Flexmonster calculated the Grand Total.

  1. instead of that, Let’s assume we have a Grand Total value from server request call, can i apply the Grand Total to every cell instead of Flexmonster Grand Total value?
  2. Can we change the formula for the Grand Total?
  3. Can we hide the “Grand Total” value for the particular measure or particular cell?

Give me the solution ASAP.
Thanks and regards
Ravi A

1 answer

Vera Didenko Vera Didenko Flexmonster May 12, 2020

Hello, Ravi,
Thank you for writing to us.
1-2. About providing a custom Grand Total value or changing the formula for calculating the Grand Total:
We would like to kindly explain that using a different aggregation for calculating the Grand Total is not supported at the moment.
We have added this request to our customer’s wishlist and we will inform you in case of any changes. 

However, it is possible to provide a custom Grand Total value via the custom data source API approach released in the new major release version 2.8 of Flexmonster.
This approach greatly improves the performance and provides full control over how the data is processed. This means that now it is possible to implement your own server-side connector to the database or any data source and feed the data into Flexmonster already in the aggregated form.
Please see the following guides for more information:

3. About hiding the Grand Total value for a specific field:
Hiding specific Grand Total cell values is possible by using the customizeCell() API call.
Please see the following JSFiddle example we have prepared for you.
In the provided JSFiddle, the Grand Total for "Discount" is hidden.

Please let us know if this helps and if you have further questions that we can help with.
Looking forward to your reply.
Kind regards,

Please login or Register to Submit Answer