Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
| Channel | Sales | Brand | Dept |
|---|---|---|---|
| Channel1 | 1235 | Samsung | Phone |
| Channel2 | 354 | Blackberry | PDA |
| Channel3 | 941 | Oppo | Phone |
| Channel4 | 341 | Nokia | Phone |
| Channel5 | 924 | Sansui | Phone |
| Channel6 | 1733 | Toshiba | TV |
| Channel7 | 1460 | Apple | Phone |
| Channel8 | 1177 | Micromax | TV |
| Channel9 | 1719 | Le10 | Phone |
| Channel10 | 917 | Maxima | Watch |
| Channel3 | 1585 | Apple | Phone |
| Channel4 | 1828 | Micromax | Tablet |
| Channel5 | 689 | Le10 | Phone |
| Channel6 | 1364 | Sansui | Phone |
| Channel7 | 1774 | Toshiba | TV |
| Channel8 | 232 | Apple | Phone |
| Channel9 | 1093 | Micromax | Phone |
| Channel10 | 1677 | Le10 | Phone |
| Channel1 | 375 | Maxima | Phone |
| Channel2 | 1579 | Le10 | Phone |
Hi I want to have the saleswise top 5 channels in text or string format not in number format .
I have tried
for first ranked channel - Aggr(if(Rank(Sum(Sales))=1,Channel),Channel)
similarly for second , third , fourth and fifth i have used 2,3,4,5 but this is returning me in number format.
Actually I need to feed this as an input to a set analysis where condition so it is important that this is in text or string format. Please provide any pointers.
And the expression editor shows an explicite error message?
The advanced search will not be evaluated and interpreted by the syntax checker, so I think you shouldn't be worried by the coloring alone.