# Formulas for Grand Totals in Saiku

• 07-14-2015, 10:57 AM
Drew
Formulas for Grand Totals in Saiku
Hello,

I am creating a Mondrian Cube and using it in a Saiku Analytics Report.

I use the option in Saiku to add a Grand Totals row. This works fine for all the columns which are summable. However, there are columns for which I want to tell the system not to apply the sum but in the case of a sum row, apply the row-wise formula.

For example the below table shows a Ratio% column which is ColumnA / ColumnB as a percentage. When I apply the Grand Total row using the Sum aggregation, I get the sum of the percentages as shown in red below.

 Session ColumnA ColumnB Ratio% A 56 57 98,25% B 40 45 88,89% C 32 42 76,19% Total 128 144 263,32%

How can I tell the schema or Saiku that in case of a Totals row being added, that column should not be summed up but it should rather apply the formula applied to the calculated member?

• 07-14-2015, 12:09 PM
gutlez
This looks like the same thing as:

In that thread, the user was advised to go to the Saiku forums/support pages.
• 07-14-2015, 01:08 PM
emicarnicero
Quote:

Originally Posted by gutlez
This looks like the same thing as:

In that thread, the user was advised to go to the Saiku forums/support pages.

not the same issue

Drew: I guess you can't do this
• 02-20-2017, 11:41 PM
zealzhangz
Quote:

Originally Posted by Drew
Hello,

I am creating a Mondrian Cube and using it in a Saiku Analytics Report.

I use the option in Saiku to add a Grand Totals row. This works fine for all the columns which are summable. However, there are columns for which I want to tell the system not to apply the sum but in the case of a sum row, apply the row-wise formula.

For example the below table shows a Ratio% column which is ColumnA / ColumnB as a percentage. When I apply the Grand Total row using the Sum aggregation, I get the sum of the percentages as shown in red below.

 Session ColumnA ColumnB Ratio% A 56 57 98,25% B 40 45 88,89% C 32 42 76,19% Total 128 144 263,32%

How can I tell the schema or Saiku that in case of a Totals row being added, that column should not be summed up but it should rather apply the formula applied to the calculated member?