Multi-row formula with a rank function
- Suscribirse a un feed RSS
- Marcar tema como nuevo
- Marcar tema como leído
- Flotar este Tema para el usuario actual
- Favorito
- Suscribir
- Silenciar
- Página de impresión sencilla
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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
¡Resuelto! Ir a solución.
- Etiquetas:
- Preparation
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Hi @legwu,
This is a great use case for the Tile tool, where the Tile_SequenceNum will be your desired Rank:
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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.