I am wondering if there is a way to calculate the total based on other columns’ totals, like the attached picture.
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.