the leftmost is brand name i want the amazon should the 1st in list nd rest should arrange in descending order on the bases of T2%B q4 column
Hello @Siddhi_21 hope this message finds you well
you can customise column sorting using calculated fields. To sort a column based on another, such as having “Amazon” appear first and the rest in descending order based on the “T2%B q4” column, you can create a calculated field for custom sorting. Use an ifelse
expression like this: ifelse( {Brand Name} = 'Amazon', 9999, {T2%B q4} )
This assigns a high value to “Amazon” so it always appears first, while using the original values for others. After creating the calculated field, apply it to sort your visualisation by dragging it to the sort area or using sorting options. Ensure your visualisation is set to display data in the desired order, adjusting sorting settings as necessary. This approach will allow “Amazon” to appear first, followed by other values in descending order based on the “T2%B q4” column.
Please, tell me if it’s work for u
THANKU so much @lary_andr it works for me…by putting timeperiod function in it
@Siddhi_21 please, could you flag my answer as a solution? thats help me to grow in the community