Would it be possible to rank on 2 metrics calc metrics at same time.
is this possible?
Please check attached workbook,
1. Sheet1 : Two ranks
2. Sheet2: Dynamic Rank: by sales or by profit ratio
Hope that helps you.
Thanks for your time!
Retrieving data ...