Issue while Calculation sub total in pivot chart

[Anonymous]

Hey Friends,

I am unable to calculate correct Subtotal for expression having one dimension called YearMonth.

YearMonth	WI Revenue
201704	1,748
201705	1,948
201706	1,985
201707	2,177
201708	1,872
201709	1,783
201710	1,829
201711	1,721
201712	1,824
201801	1,837
201802	1,667
201803	1,832
Total	-

I tried using Dimensionaly() to get the total but still i m unable to derive the total nos.

Could you guys please help me on this.

Thanks & Regards,

Girish Chhatani@

[sunny_talwar · Accepted solution]

What is your expression here? Use Sum(Aggr(Expression, YearMonth))