Strigh table issue

[soniasweety]

Hi all ,

I  have an issue in stright table . i don't know is it possible or not?

I have attached input and output  in excel .can anyone help on htis?

Thanks

Sony

[sunny_talwar]

Like this?

Calculated Dimension

=Aggr(Rank(-Sum(Sales)), Region, City)