Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a Table with 5 field in the following order. user wants to sort order like Tier-1, Tier II, Tier-III, High, Medium, Low. Please suggest.
Thanks a lot. It worked.
Hi, you have to create another one column with the sorting order and put it as an expression into the sorting option of the desired visualization.
MAP: MAPPING LOAD * Inline [ A, Ord High, 4 Low, 5 Tier1, 1 Tier2, 2 Tier3, 3 ]; LOAD *, ApplyMap('MAP', A) AS Ord; LOAD * INLINE [ A High Low Tier1 Tier2 Tier3 ];
or you can sort by expression"
match(Priority,'Tier-1','Tier II','Tier-III','High','Medium','Low')
Thanks a lot. It worked.