Pivot VBA-do not include negative values for summation in Values Field

[machumpion]

I have a sales dataset which includes alot of negative values in the 'order' field which represents discounts applied.

I wish to calculate the gross amount of sales (ignores discounts). How can I quickly do this without putting the Order field in Report Filter and unchecking all the negative values before putting it into the Values field?

 

[Rx_]

Probably use a Sum IF formula.
Look at this example - then search on the Internet - there are many variations and examples. Be sure to post your best solution! Others are sure to thank you for it.

https://www.extendoffice.com/documents/excel/1419-excel-count-sum-positive-negative-numbers.html