Percent_of_total with filters doubt

Hey guys! I’m a Looker rookie, so this might have a super easy solution that i may not know about yet.

My problem is the following:
I have a measure that is type percent of total, and I’m using it to calculate the percent of total revenue that each product represents in a certain month.
The thing is that when I filter out some products, I want it to still calculate the percent of total over all of the products, not just the ones that appear in the table.

Any ideas??

Thanks in advance!

0 4 844
4 REPLIES 4
Top Labels in this Space
Top Solution Authors