For example, let’s say I have list of retailers and the revenue numbers for each.
If I filter the list to show only retailer A, I still want to have the total revenue of all retailers (let’s say for comparison) somewhere. But if I use a table calculation like (sum(revenue)) the total changes when I filter (showing only revenue for retailer A, not the whole dataset with all retailers).
How do I get a column total that doesn’t change with filtering, so that I have a total value for comparison for every individual retailer?