How to show sum and average of a column in matrix

[Kandarp]

I am trying to show sum and average on a column in a matrix like the below screenshot. I have done some research but I am not sure is it really achievable or not. I need some guidance. Thank you.

[TheoC · Accepted solution]

Hi @Kandarp 

I do not believe it is possible to have the subtotals show an average AND sum.  You can do either or.

There is a workaround. Basically you can create two matrix tables and have one behind the other.  Once you set it up, you can offset the one at the back to be further down a bit and use that as the "Average" while the one on top is the "Sum".

Other than that, am not sure it's possible in the same column.

All the best.

Theo 🙂

[TheoC · Accepted solution]

Hi @Kandarp 

I do not believe it is possible to have the subtotals show an average AND sum.  You can do either or.

There is a workaround. Basically you can create two matrix tables and have one behind the other.  Once you set it up, you can offset the one at the back to be further down a bit and use that as the "Average" while the one on top is the "Sum".

Other than that, am not sure it's possible in the same column.

All the best.

Theo 🙂

[Kandarp]

Hi @TheoC 

Thanks a lot for the quick response. 

This solution works for me. 

Thanks. 🙂 

[TheoC · Accepted solution]

@Kandarp a pleasure mate! Glad it worked! 🙂