Calculating % relative to Total with Multiple Filters in Different Tables

Hello, I need to use the total from one chart in another chart to calculate the % of each data point relative to this grand total. All data is from the same table. I also need to apply a filter to display only a subset of the values.
When I select a single month, I can achieve this, but when I select multiple months, the data is incorrect.

What's the best way to handle this situation?

Note that I have Looker Studio and don't have access to LookML.

Thanks for your help 🙂

 

 

Screenshot 2023-09-22 at 9.25.52 AM.png

0 0 105
0 REPLIES 0
Top Labels in this Space
Top Solution Authors