Pull a rank into a scorecard
I have a Google spreadsheet that loads into DS with the total number of FB followers for my company and a number of our competitors. I've created a table with row numbers to get at a rank. However, I'd also like to pull just my company's rank into a scorecard. Is there any was to do this through a calculated metric to create the rank, without having to make it via formula in GS? The complicating factor is that we have both local and national competitors, and I want a separate rank for overall, local, and national.