Forum Discussion
Solved
Comparing Values and scorecards based on a lookup table
I have 2 tables of data (see below example), 1 with a listing of a bunch of reviews on sports with a star rating. I have another table thats a reference that says what sport i should benchmark it ag...
Perhasp if you did this:
Table1 * <- 1 Table2 (get rid of your benchmark column) 1 <-> * Table3
So your Table1 and Table3 as presented below minus the Benchmark column in Table2
Create a third table:
Sport,Benchmark
Football,Football
Hockey,Football
Football,Hockey
Hockey,Hockey
...
Use Benchmark for your slicer. Use Table2 sport or Table3 Sport for you axis.
Might work.
- Thanks Greg_Deckler.
I will try it but I’m guessing when I slice by benchmark I’ll only get the 1 sport, rather than both the benchmark and main sport.
