Not able to get desired output on matrix

[Anonymous]

My data is in the format given below.

Required output is shown below

 Column B represents total number of accounts in that month. 
I'm not able to get the total in column B.

Thanx in advance.

[v-shex-msft · Accepted solution]

HI @Anonymous,

You can create a new table with all column values and add custom value 0, then you can use this new field on the column field and write a measure expression with if statement to summary values and replace the result if the current column value is equal to 0.
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , You can enable column total in matrix. But I doubt you can move that to first place.