hello team, do you know if we can filter the SUM of the measures in a pivot table in analytics? I'd like to exclude the zero SUM of the values

I am not sure, but maybe just modify the query to not include zero's in the dataset?

It doesn't fix the problem since the SUM of the transactions end up zero, not the transaction itself

But if you remove zeros, then the sum will also equal zero, unless you positive and negatives in this.