Negative numbers in pivot table
If this was me, I would create separate columns in the data table for
positive sales and negative sales. Then summing them separately in the pivot
table is easy.
Regards,
Fred.
"Alonso" wrote in message
...
I have a table with sales
some of them are negative cause those were returned by the customers
I'm trying to get a pivot table with the total
but to show somewhere the positives
then the negatives
and at the end the grand total
can this be done??
|