How to ignore filter context on the calculation of totals

Hello everyone,

I am new to looker and I am figuring out several things still. I want to perform a calculation on the total row however that total row is being affected by my filters which i dont want to do.

Shop Sales
A 10
B 10
Totals 20

What I want is to filter by Shop A but still show the total amount of sales I had.

Shop Sales
A 10
Totals 20

How can i achieve this?

1 3 4,802
3 REPLIES 3
Top Labels in this Space