Problem with aggr function

[#1]

Hi All

I want to calculate % for above rows i.e. 367/5793 and 5426/5793

I used aggr function for calculating 5793, but it is not populating in all rows

please help..

[sunny_talwar]

What are the expressions that you are using here? I think you are using Aggr() function, but it would be better to use Count(TOTAL <Region> .....) for denominator. Although, if you do want to use Aggr(), you need to use NODISTINCT -> Aggr(NODISTINCT ....)