cross pivot table with fix total column and row

[#1]

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.

T.

[#2]

Try with this:

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

Regards,

Ricardo

[#3]

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

Thanks.

T.

[#4 · Accepted solution]

Ok,

Try with this:

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

Regards,

Ricardo

[#5]

Great, it is working perfectly.

Thanks.