Need a special offer?Find out if your project fits.
+

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