topic Make selection and without change subtotal in Pivot table in QlikView

Make selection and without change subtotal in Pivot table

Anonymous — Fri, 19 Oct 2012 15:57:08 GMT

Hello,

I try to select one of Project Manager (CHEN, V) , I want to show the total 108 % for this employee, not just 13%.

Is it possible ?

Thanks, H

Fri, 19 Oct 2012 16:04:15 GMT

Hi use

if( [Project Manager]='Chen, V', sum(Total fieldname), sum(fieldnam) )

Hope it will help

Regards

-Anil