Any Tricks to Get a Metric Widget to Reference Report Data?

Options

Hi,

I am looking to create 3 metric widgets in my dashboard that reference the cells highlighted in red from the report below...

It appears that I can only reference a sheet or sheet summary to create a widget. However, is there any work around to get this to work (i.e. build a sheet that references these cells, etc)?

Answers