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

machumpion

Registered User.
Local time
Today, 09:50
Joined
May 26, 2016
Messages
93
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?
 

Users who are viewing this thread

Back
Top Bottom