grand total without totaling a column

#1

Hello,
I have a table (rectangle in red), every row in the table has a column (last column) with a formula and is working good. But this formula in the grand total is not correct (yellow mark). This is because Dundas is totaling this last column instead make the formula ($Net line amount$/$Net line amount PoP-1Year$)-1, so the correct amount should be 295.68% instead 159.86% . Is there any way to avoid this total and use my formula in the last column of this table?

image
image.png1406×657 87.3 KB

Thanks,

#2

I think you’re looking for a custom totals calculation as described here:

https://www.dundas.com/support/learning/documentation/analyze-data/using-a-custom-total-calculation

1 Like
#3

Thank you so much Terrence, that’s just what I was looking for!

1 Like