🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Setting up a formula

Closed
Blitz 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?

Attachments:
1.png

1 answer

Public
Vera Didenko Vera Didenko Flexmonster 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