Show the variance between 2 scorecards with a site filter

[Brian2605]

Hi, hoping someone can help me with the above, I have 2 line charts showing sales with a site filter on each to compare, I have added a scorecard for each table and when the filter is changes the scorecard updates as expected. I have been asked if I can add another scorecard that will show the variance between the 2 sites chosen from the filters on the charts.

I have found a few ideas but nothing that works with a dynamic site filter.

[sam8]

I don't think this will be possible in Looker Studio. I'd recommend creating a feature request. 

You might be able to achieve this in Looker, but it would require using templated filters to capture the values of both filters, and then applying that logic to another measure.