datastudio function ranking or herarchize

Dear friends, I need your help to generate a kpi. Exactly I need to hierarchize, and to know what position occupies an attribute inside a relation. I explain it with an example: vendor attribute (apple, samsung, xiaomi, oppo ...), period (quarter), and I have two metrics, sales volume, and total sales volume. Let's imagine that apple sells 10.000, samsung 4000, xiaomi 2500 and oppo 100. In the samsung record we would have: sales 4000 and total sales 16.600. I need to generate a metric that tells me that it is position 2.

how can I solve this? thanks all

0 0 66
0 REPLIES 0
Top Labels in this Space