@SCK -
I've attached a workflow that should help you if you're trying to mimic the highlighting capability! You will need to use a Reporting Table.
I think you said you wanted to highlight the top variance values instead of the 'various value'? Is that correct?
I created a rule in the Report Table that highlights the top variances using a variance rank field that I created:
If this helps, please mark this as a solutions!
Best,
Ashley
Yes!
So before I explain the formula, here's what I did overall:
I filtered to only have the rows of data where 'item #' ='total variance', I sorted the data by PY amount & used the Record ID to create a Rank called 'Variance Rank' (since you only want to see top 2). That rank gave me the Total Variance ranked 1-4:
After, I bring the data back together with a union and sort the data back into it's original order.
On the bottom of the Report Table building block there is a 'Per Column Configuration'. I clicked 'PY amount' and then to the right, I selected Column Rules. I created a new column rule using a formula to only highlight the 'PY amount' if the rank was less than 3 (ultimately giving me the top 2 variances). I created it so 1 is true and 0 is false. If it's true, I changed the background color to green:
