Idea Summary
When creating KPIs reports (using classic report for example with the source beeing SQL query), we have calculated columns that correlate other columns from the base, and most of the times we need to have a total row at the end of the report. We build this total row with by enabling the option “Compute Sum”, but it is not possible to use this in the calculated columns. So, lets say we take a percentage based on column “A” and column “B” to build column “C”. While we see the calculated data on the rows, we cant have the calculation performed based on the total values of columns A and B, and so the total of the column C stays empty. So, the idea is to allow a calculated column to have an option to take part on the total row of a report by taking into account the total values of the other columns.

Use Case
This can be used on KPIs reports or any other report that have calculated columns and needs to have a total row to consolidate data.

Preferred Solution (Optional)
A solution could be to extend the SQL calculation used to create the column to the total row, and allow the user to enable the option to calculate the total of these columns.