How to get Totals (Sum) and Average in the same table.

[#1]

Hello everyone.

I have created a table using different expressions. The total (sum) has been created in the end, which is fine but I also want an average row below Total. Is there any way in which I can do that?

Thank you.

[sunny_talwar]

May be use a pick(match(dim....)) approach with island table or use a synthetic table approach.

Subtotals and multiple dimensions in a barchart‌ (used here for bar chart, but can be used for straight table and pivot table)

[maheshkuttappa]

Attached Solution..........