I am looking to aggregate a metric by a ranked dimension by i'm getting some errors:
Make
Model
Price
Ford
Focus
$5,000
Ford
Mondeo
$8,000
Peugeot
206
$2,000
Peugeot
106
$5,000
Toyota
Yaris
$4,000
Toyota
Camry
$12,000
Toyota
Premio
$8,000
Honda
Civic
$2,500
Honda
hr-v
$4,000
Above is a test example. I want to find the top 2 'Make' based on the highest price (in this case Ford = $13,000 and Toyota = $24,000). Then based on them, I want to count how many models there are (in this case Ford = 2 and Toyota = 3).
The final output I want is just the metric 5 (2+3). I have used lots of different combinations of aggr, rank, variables etc but cannot get it to work without pulling in the 'model' dimension as a table.
Any help of how to do this so that I can just display 5 as a metric would be much appreciated.