Percentage by total

[pgalvezt]

Hello!

I have tried to obtain the percentage by total. Sum(Monto)/Sum(TOTAL(Monto)) but doesn't work

also I tried Sum(Monto)/Sum(TOTAL(<Dimension>Monto))

2013	2014
279.546.344	265.724.196	4,91%
284.068.632	50.038.435	4,99%
2.461.684.247	2.396.134.301	43,25%
1.017.790.251	1.052.756.852	17,88%
58.968.103	39.347.902	1,04%
53.482.772	46.779.317	0,94%
1.254.410.643	1.673.510.430	22,04%
93.477.680	25.073.305	1,64%
76.939.347	170.740.111	1,35%
111.378.982	61.719.825	1,96%
5.691.747.001	5.781.824.674

Thanks!

[Anonymous · Accepted solution]

Try an expression of

     Sum(Monto)/Sum(TOTAL <Periodo> Monto)

You also have loads of rows where [Activo_Circulante]  is null so untick Suppress When Value Is Null from it on the dimension tab.

[PrashantSangle]

Hi,

Try like,

Sum(Monto)

/

SUM(TOTAL<Periodo> Monto)

*100

and change format from number tab.

Regards

[Anonymous]

See this.

[ecolomer]

See this: