Measure filters don't apply to totals

I have a Look similar to this one:

Customer (dimension) % of good reviews (measure) % orders reviewed (measure)
Customer name 1 15% 90%
Customer name 2 10% 1%
Customer name 3 20% 10%
Total 12% 85%

I have a “% orders reviewed” filter and I filtered by % orders reviewed > 15%. I would expect the total row to change, so it would be 

Customer (dimension) % of good reviews (measure) % orders reviewed (measure)
Customer name 1 15% 90%
Total 15% 90%

But it doesn’t change. It remains like:

Customer (dimension) % of good reviews (measure) % orders reviewed (measure)
Customer name 1 15% 90%
Total 12% 85%

I’ve read Looker documentation and I understand the “totals” row is calculated before the filter applies. 

It is ok… but I am really trying to find an alternative here…. My objective is to see how the “% of good reviews” changes when I apply measure filters (ex: % orders reviewed). I know I could do that using a derived table, but I would appreciate if there is any other alternative. 

OBS: This is just a simple example, my database is big 

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