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?