Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm here again to ask about Ranking vendors....
I have a table that have the three left columns, i have to add the last two :
How can i calculate the price ranking and sector ranking COMPARED WITH THE TOTAL AND ignoring all the selections made by the user?
I have this formula:
=rank(total(sum({1}PRICE))) , but i dont know how to add the count of the total (already tried =rank(total(sum({1}PRICE)))&'/'&count(VENDOR) but didn't worked...)
I assume your table is a table in the data model, and not a table in the UI?
I would try a chart (UI table) with the following for the total ranking:
and the following for ranking within each sector