To answer your question I have attached a workbook.
I created a couple of calculations:
If [Home Away] = "Home" then [Score] END
If [Home Away] = "Away" then [Score] END
Home or Away Club
If [Home Away] = "Home" then "Home Club"
ELSE "Away Club"
I then created two sheets and combined the sheets on a dashboard.
Hope it helps!
Example.twbx 17.3 KB