Grand Total field using formula not show the sum

Answered
Stefan asked on March 4, 2026

Hello team,

I saw different tickets related with that behavior and I am not sure if there is some new changes done for this one or not.

So my question is the following:

If we get this pivot table: https://jsfiddle.net/50aL7xvs/8

and change the Formula#1 to = sum("Val1") / sum("Val2")

First lest confirm that the default behavior is to get the the same formula expression also for the Grant Toatal.

And is it possible somehow to get in the Grand Total for that column the sum of all above ?

 

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 5, 2026

Hello Stefan,

Thank you for the question.

We want to confirm that the totals for the calculated measure are calculated using the same formula. Currently, Flexmonster only supports totals based on the same formula, not on the sum of the values.

However, the request to define separate aggregations for totals is already included in our Customers' Wishlist. Our team will notify you about any updates on the matter.

You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Please sign in or register to submit your answer