Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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@
What is your expression here? Use Sum(Aggr(Expression, YearMonth))
What is your expression here? Use Sum(Aggr(Expression, YearMonth))