Regarding row summation in pivot tables, it is recommended to add an option to sum by absolute value. This applies to the following scenario: there are two columns, one with normal positive numbers and the other with abnormal negative numbers. In this case, the total quantity should be summed by absolute value . Thank you.
Hi there,
I believe you could do this by adding a custom column with the expression abs([Column]), and then using a normal Sum on the custom column, would that work?