Hi,
I have loaded a table (named "Data") into Powerpivot and would like a measure to rank by Product in each city using a ref number.
I also want this rank to stay even if I filter later.
<tbody>
</tbody>
Hope you can help.
Thanks,
John
I have loaded a table (named "Data") into Powerpivot and would like a measure to rank by Product in each city using a ref number.
I also want this rank to stay even if I filter later.
City | Product | Ref | RANK I want |
Sydney | Bike | 100 | 1 |
Sydney | Bike | 102 | 2 |
Sydney | Bike | 105 | 3 |
Sydney | Bike | 112 | 4 |
Sydney | Bike | 113 | 5 |
Sydney | Car | 101 | 1 |
Sydney | Car | 103 | 2 |
Sydney | Car | 104 | 3 |
Melbourne | Bike | 106 | 1 |
Melbourne | Bike | 108 | 2 |
Melbourne | Bike | 111 | 3 |
Melbourne | Car | 107 | 1 |
Melbourne | Car | 109 | 2 |
Melbourne | Car | 110 | 3 |
<tbody>
</tbody>
Hope you can help.
Thanks,
John