Calculate Column Total

[17mcmc20]

Hi All,

I have created a table (not a Pivot table) for the scorecard. I need to calculate the total column-wise for Development and Current

Score	Development	Current	Change (Development - Current)
0-200	123	112	11
200-400	345	320	25
400-600	678	650	28
600-800	910	909	1
800+	1010	1000	10
TOTAL	3066	2991	75

NOTE: Development, Current is Dimensions;  Change is Measure

Any suggestions would be really helpful.

[lorenzoconforti]

Can you just maybe replace those dimension fields with measures?

Something like:

sum(Development)

sum(Current)

[17mcmc20]

How can I replace the Dimension fields to Measures?

[lorenzoconforti · Accepted solution]

Add column >  measure

only(Development)

Add column >  measure

only(Current)