Negative numbers in pivot table

A

Alonso

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??
 
F

Fred Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
How to ignore a column of numbers in Grand Total for rows 1
pivot table, grand total no negatives 3
Negative Numbers in a Pivot Table 1
Pivot Table Sales Projections column 2
Pivot table in Excel 2007 1
help calculating tax and total in pivot chart 2
In Pivot table sort 1

Top