Hi,
I have a tricky situation where I need to perform a function on certain groups of the data. That is, if I group the data by a unique combination of fields, then I need to rank the values in a certain field and give the rank position.
I have attached an example of what I mean.
In this example, lets say I wanted to populate the 'Rank' column. This would show me which Branch sold the highest/lowest when grouped by Company Name and Code. Is there a multi-row formula I could use to do this?
My initial idea is to create a list of unique groups, run a macro using Filter, Sort and Record ID. Is there another way
Thanks,
Lincoln
Solved! Go to Solution.
Hi @legwu,
This is a great use case for the Tile tool, where the Tile_SequenceNum will be your desired Rank:
Hi @legwu ,
I think, Sort tool and Multi-Row Formula tool do the job ...I've attached a sample workflow.
Let me know if it works for you.
Best,
Roland
Thanks for the solutions all, they all work! I have never used the Tile function before, but it is very useful here aswell. Much appreciated.