Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I would like to have your support in two challenges I am facing in my application.
#1
I have a table with my company´s suppliers, which is sorted by theirs deliverable grades (from the highest to the lowest). I would like to add in this table a column with the rownumber and also in which percentile this supplier is among all of them (the table is below: the suppliers are in the first column - dimension - and they are sorted by their grades - the last column ("NOTA GERAL").
#2
Using the application´s filters, I would like to keep at least the supplier percentile even if its also filteres (e.g. I would like to see that "PRIMO FACTORY" is in position number two, even if the user filter only him (keeping all the others filters on))
If I was not clear enough, please tell me!
Regards and thank you in advance!
3 new columns:
Rank:
Only(Aggr(Rank(Sum({1} GRADE)) * Avg(1), SUPPLIER))
#SUPPLIERS:
=count({1} total DISTINCT SUPPLIER)
Percentile:
=(#SUPPLIERS-Rank)/(#SUPPLIERS-1)