I have 2 Dimensions :
First Dimension, I used : aggr(Count([Score]),[Dimension1]) sort Descending and it is working fine.
However, the Second Dimension: aggr(Count([Score]),[Dimension2]) sort Descending is not behaving like the first.
I got this result:
Dimension 1
Dimension 2
Count( Score)
Program 200
Entrepreneur 88
Business 90
Shop 70
Business 180
Gas 99
Garments 90
Metal 98
ABC 150
Special 50
Regular 80
Expected Result:
Count( Score)
Program 200
Business 90
Entrepreneur 88
Shop 70
Business 180
Gas 99
Metal 98
Garments 90
ABC 150
Regular 80
Special 50
Please help with the correct expression. Thank you!
