HI all,
Can any one help me with the sorting issue in straight table, when there are common names under a dimension.
I've the data as below
| Country | Department | SALES |
| USA | ETS | 200 |
| USA | BFSI | 0 |
| UK | ETS | 1000 |
| UK | BFSI | 23 |
| India | ETS | 63 |
| Japan | ETS | 250 |
| Japan | BFSI | 89 |
| South Africa | ETS | 91 |
and I would like to sort the countries based on the sales
and I would like to the see the output as below.
| Country | Department | SALES |
| UK | ETS | 1000 |
| Japan | ETS | 250 |
| USA | ETS | 200 |
| South Africa | ETS | 91 |
| Japan | BFSI | 89 |
| India | ETS | 63 |
| UK | BFSI | 23 |
| USA | BFSI | 0 |
Currently sorting the dimension based on the numeric value doesn't give the desired output as there are common names under country.
Pls help me with this.
Thanks,
Surendra
