Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Ok,
Try with this:
if(ColumnNo()=0, Sum(Aggr(Sum({< Project_Phase= >} Value), Vendor)), sum(Value))
Regards,
Ricardo
Try with this:
if(ColumnNo()=0, Sum({< Project_Phase= >} Value), sum(Value) )
Regards,
Ricardo
Great, it seems that it is working, but how I can hide other phases which are now zero?
Thanks.
T.
Ok,
Try with this:
if(ColumnNo()=0, Sum(Aggr(Sum({< Project_Phase= >} Value), Vendor)), sum(Value))
Regards,
Ricardo
Great, it is working perfectly.
Thanks.