Problem with aggr()

[#1]

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

[#2]

I have solved it by using Total<> instead of aggr().

[#3]

Another way: Still use aggr, but this this , add nodistinct