topic cross pivot table with fix total column and row in QlikView

cross pivot table with fix total column and row

Tue, 19 Mar 2013 21:44:32 GMT

Hi,

I have cross pivot table with two dimension Vendor and Project Phase and one expression Amount and Overall column and row.

Is there option how to fix Overall column and row? So if i choose Vendor or Project Phase filter, Overall values will be fixed for all vendors and phases.

Example on picture.

Thanks for help.

Re: cross pivot table with fix total column and row

Tue, 19 Mar 2013 22:51:37 GMT

Try with this:

if(ColumnNo()=0, Sum({< Project_Phase= >} Value), sum(Value) )

Regards,

Ricardo

Re: cross pivot table with fix total column and row

Tue, 19 Mar 2013 23:48:32 GMT

Great, it seems that it is working, but how I can hide other phases which are now zero?

Thanks.

Re: cross pivot table with fix total column and row

Wed, 20 Mar 2013 01:56:37 GMT

Ok,

Try with this:

if(ColumnNo()=0, Sum(Aggr(Sum({< Project_Phase= >} Value), Vendor)), sum(Value))

Regards,

Ricardo

Re: cross pivot table with fix total column and row

Wed, 20 Mar 2013 06:49:04 GMT

Great, it is working perfectly.

Thanks.