Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In the Pivot table, I have the expossre of activities into different part (any number betweeb 0 to 1).
my expression is: =sum(Exposure_Weight)
It works perfectly fine. But when I try to reweight them by the partial total of expsoure, using:
=
sum({$<Type_Sub={"*"}-{[Others]}>}Exposure_Weight)*(100-Rest)/aggr(sum({$<Type_Sub={"*"}-{[Other]}>}Exposure_Weight),Year,Month)
I can get the partial total figures correst. But there is one reweighting figures shown on the table after Type_Sub and other rows just shown "-". If I click to different Type_Sub, there correct figure is back and only for that one.
Is there anything wrong?
Many thanks,
Ivan
I have solved it by using Total<> instead of aggr().
Another way: Still use aggr, but this this , add nodistinct