Take out the % into the total of a pivot table

[fkeuroglian]

Hi Expert

I have a situation:

1 have a pivot table and i have a value that is a % and its is sum to my total in the pivot table

for example i attached the solution and the qvd and you will see that there is a field marked in red that the value is not a number, it is a % percent value.

i want to take out this value and do not sum in the total, do not see in the total.

for example in the qvw attached, the total is: 1817529.5 but the %2.5 is sum to this number, i want to take out, but show in the pivot table.

the total have to be 1817527 and not sum the %2.5 percent as a number to the total.

attached the qvw and qvd

thanks a lot

Fernando K.

[Anonymous]

you can omit all fields starting with % enhance your set Analysis

sum({<nombre-={"GASTOS RRHH","%*"}>} valornuevo)

[fkeuroglian]

Thank for your answer Rudolf, but as i said:

"for example in the qvw attached, the total is: 1817529.5 but the %2.5 is sum to this number, i want to take out, but show in the pivot table"

i want to show in my table, but not sum to my total.

Thanks a lot

[antoniotiman · Accepted solution]

Hi Fernando,

may be

If(Dimensionality() = 0,sum({<nombre-={'GASTOS RRHH','% s/Ingresos'}>} valornuevo),
sum({<nombre-={"GASTOS RRHH"}>} valornuevo))

Regards,

Antonio

[fkeuroglian]

Thank you Antonio

its work!

Fernando K.