Percentages of total subdimension

[#1]

Hello

I have the following Table:

Instead of the number of the dimensión GRUPO_SERVICIO I want to have the porcentages that this number represents according to the sum.

Example for the TIENDA COPYFACTORY Instead of have GDF=4,845 METROBUS=85 etc. I want to have the porcentage that these numbers represent according to the total 5,997

Please Help

Thanks in advance

[MarcoWedel]

Hi,

one solution could be:

hope this helps

regards

Marco

[ramoncova06]

algo asi te debe de funcionar

if(Count(TOT_TRAN)/Count(Total <Tienda> TOT_TRAN)= 1,

Count(TOT_TRAN),

num(Count(TOT_TRAN)/Count(Total <Tienda> TOT_TRAN),'#,##0.00%')

[MarcoWedel]

Hi,

another solution:

hope this helps

regards

Marco