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

[#2]

ALL IS 0

[sunny_talwar]

I understand what you are aiming for, but not sure why it isn't working. Would you be able to share a sample with us?

[#4]

Hi

Sorry I dont understand you well, what do you refer with and example, what you need?

Thanks for your help

[sunny_talwar]

A sample qvw file to see the issue?

[ramoncova06]

in theory this should work

Count(TOT_TRAN)/Count(Total <GRUPO_SERVICIO> TOT_TRAN)

[sunny_talwar]

I agree

[#8]

Not it´s not working...Give me a bucnh of 0's

[ramoncova06]

are you applying any rounding ?

have you checked in the number properties and enabled % ?

[ramoncova06 · Accepted solution]

sorry forgot that the grouping is done by store, so switch it to store instead of servicios

Count(TOT_TRAN)/Count(Total <Tienda> TOT_TRAN)

[#11]

Great Ramón It's working:

Only one Question Left:

It its posible to have the lasto column with the total of transacctions and not with the 100%???