I have a pivot table where I'm trying to find all the losses. So I'm seeing all the values, where 80% are positive, but I only care about the negative ones. Is there a way to show only negative values? Please note, this isn't just in the grand total column - I want this in the entire grid.
For example
<tbody>
</tbody>
That's a lot of #s to go through. I only care about the negative ones, which is 3 out of 12. Is there a way to just show those?
For example
Province | 5km | 10km | 15km | 20km | |||||
Alberta | $500 | -$30 | $200 | $100 | |||||
BC | -$20 | $1000 | $1000 | $1000 | |||||
Ontario | $400 | $400 | -$200 | $0 | |||||
<tbody>
</tbody>
That's a lot of #s to go through. I only care about the negative ones, which is 3 out of 12. Is there a way to just show those?
Last edited: