asked on May 27, 2021
Good afternoon, you need to make the formula read the product of the columns, and in the end output the sum of the rows received, and not the same product.
The screenshot shows that the product of the columns is calculated correctly, but in the Total field, the product is also calculated by entering a total of 82,800, but you need to enter the sum of the rows equal to 27,390.
Can this be implemented?
⋅ May 27, 2021
Hello,
Thank you for writing to us.
We would like to kindly explain that using a different formula for calculating the Grand Total is not supported at the moment. Still, this feature request is in our backlog, and we will inform you in case of any changes.
If desired, you can hide specific Grand Total cell values with the customizeCell hook. Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/L0w6prm8/.
Please let us know if other questions arise.
Kind regards,
Vera
This question is now closed
