Forum Discussion
daniel_ricardo
3 years agoFrequent Visitor
ranking
I need to rank sellers based on a field that is not being filtered in the visual, just by the team that the seller belongs. It's a report made to the seller, so he must see his position among sellers...
FreemanZ
Super User
3 years agotry to provide some sample data?
daniel_ricardo
3 years agoFrequent Visitor
04-03-2023 10:29 AM
Sorry, I can“t share because some data privacy, but if it helps here is the data model with relevant fields to my expression. We need to get the ranking position by des_gestor, segmento and dim_agencia.porte_agencia.
chave_ua_cart is the lowest level
des_gestor (seller) can be present in more than one chave_ua_cart
des_gestor can work in more than one segmento but must be part of one single dim_agencia.porte_agencia