Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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 ....)