Hi Community,
Currently i had built the workflow and the result as per screenshot below :
However, i would like to do some sorting on the figure for the column F with the criteria below:
1. For each respective entity, i plan to do sort the value under the column F from the largest to the smallest accordingly for each entity. The desired result will be as follow :
After performing the sorting, i would like to ask Alteryx to do some colouring on the full row based on the criteria below:
2. Based on the top three amount under column F for each entity, colour the respective row with green colour for each respective entity . If the entity only have one or two amount (less than three) under column F, just colour the relevant one or two row for each respective entity. The result will be as below:
May i know if anyone know how to do the sorting and colouring in this case? I had also attached the workflow for your reference.
Many thanks in advance
