Because each of the other reference fields is not included in the Aggr grouping parameters, it is not aggregating with reference to them. This can create extremely inconsistent results. Make sure to include all the relevant dimensions in the aggr statement, you can include more than one.
Thank you very much. But if I include other reference fields, then I will not have the total by GRCA variance. The GRCA column on the left table will become the same as the 3rd column. This is because my table on the left hand side is only top 50. The table on the right hand side is the GRCA variance by category of whole population.
I have tried using Sum (Total <GRCA> Var HKD000) but it still does not work.