Ranking

[ValeriaBonini]

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...)

[hic]

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:

• Dimension: Vendor
• Measure: Rank( Sum( {1} PRICE )) &'/'& Count({1} distinct total VENDOR)

and the following for ranking within each sector

• Dimension1: Sector
• Dimension2: Vendor
• Measure: Rank( Sum( {1} PRICE )) &'/'& Count({1} distinct total <Sector> VENDOR)