Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Calculate total based on other columns totals

Answered
Rodrigo asked on February 27, 2020

Hi Team,
 
I am wondering if there is a way to calculate the total based on other columns’ totals, like the attached picture. 
 
Thank you,
 
Rodrigo

Attachments:
Totals example.png

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster February 27, 2020

Hello, Rodrigo,
 
Thank you for writing to us.
 
We would like to kindly provide information about the way the grand totals work. The grand total of the hierarchy will be calculated based on the aggregated values of its members, not on other columns’ grand total.
 
However, Flexmonster provides the possibility to create and manipulate calculated values. Calculated values give you the option to add measures that are not presented in the original data set. Such measures are based on other hierarchies.. They can be saved and restored within the report.
 
Please check out an example demonstrating creating of the calculated value displaying the growth of sales between 2019 and 2020.
 
Detailed information about calculated values can be found in our documentation.
 
We hope it helps.
 
You are welcome to contact us in case of additional questions.
 
Best regards,
Illia

Please login or Register to Submit Answer