How to add a column without filter context

[Giansonn]

I have added a pivot table to my sheet and in this pivot I have a count of items but when I add a column reference I lose my total items that I had before. How do I keep both sets of values? Please see attached images for explanation.

You will see that the sum of the second set of values equals the first (I will remove the null column afterwards but it helps to explain by leaving it in the images - this also means that I cannot use a totals column).

[Giansonn]

bump

[Giansonn]

Still waiting for an answer on this. This should be an easy request.

[Giansonn]

bump

[Giansonn]

I have now added another row with `=count(total scan_id)`

This gives me the following output:

I am almost there. Now anyone at all... how can I filter this based on the Row values?

[Giansonn]

Bump