Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a straight table and go to sort tab
Create a straight table and go to sort tab