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

[ramoncova06]

Leonardo,

que es lo que esperas ver como total el 100% o 5,997?

[#3]

Me encantaría ver el 5,997 como total

[sunny_talwar]

What is your current expression?

This is what you need to do:

=Num(Sum(YourMeasurement)/Sum(Total <GRUPO_SERVICIO> YourMeasurement), '#,##0.0%')

HTH

Best,

Sunny

[#5]

This is my Expression

Count(TOT_TRAN)

When I use the expression that you give to me, all the values go to "0"

Num(Sum(TOT_TRAN)/Sum(Total <GRUPO_SERVICIO> TOT_TRAN), '#,##0.0%')

[sunny_talwar]

I don't think its going to make any difference, but please try this:

Num(Count(TOT_TRAN)/Count(Total <GRUPO_SERVICIO> TOT_TRAN), '#,##0.0%')

[sunny_talwar]

Would you be able to share a sample to trouble shoot it a little more

[#8]

It's the same

[sunny_talwar]

What is the result when you add another expression :Count(Total <GRUPO_SERVICIO> TOT_TRAN) what value does it give you?

[#10]

Example:

Now I have:

TIENDA                          GDF             METROBUS            SERVICIOS     TELEFONIA    TELEPEAJE      TOTAL

COPY FACTORY           4,845                  85                            8                     1,059                 -                   5,997

What I want is this:

TIENDA                          GDF             METROBUS            SERVICIOS     TELEFONIA    TELEPEAJE      TOTAL

COPY FACTORY           81%                   1%                         0%                      18%                0%                  5,997