Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Fernando,
may be
If(Dimensionality() = 0,sum({<nombre-={'GASTOS RRHH','% s/Ingresos'}>} valornuevo),
sum({<nombre-={"GASTOS RRHH"}>} valornuevo))
Regards,
Antonio
you can omit all fields starting with % enhance your set Analysis
sum({<nombre-={"GASTOS RRHH","%*"}>} valornuevo)
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
Hi Fernando,
may be
If(Dimensionality() = 0,sum({<nombre-={'GASTOS RRHH','% s/Ingresos'}>} valornuevo),
sum({<nombre-={"GASTOS RRHH"}>} valornuevo))
Regards,
Antonio
Thank you Antonio
its work!
Fernando K.