Total of Row instead of Column

[chu_en]

Hello Community,

How do i make total to right like the example on the left (with grand totals) also?

Thank You

Best Regards

[amitchandak · Accepted solution]

@chu_en , You have to create a column or measure

Total column = [column1]+[column2]+[column3]

Measure

Total measure = sumx(Table,[column1]+[column2]+[column3])

In case it matrix, you can enable column Total

[Megha166]

@chu_en 

Go to Formatting Tab and "ON" Row Subtotal