Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Negative numbers in pivot table
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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Divide 2 pivot table numbers | Excel Worksheet Functions | |||
Pivot Table exclude negative values from sum | Excel Discussion (Misc queries) | |||
Pivot Table formatting numbers | Excel Worksheet Functions | |||
Negative Numbers in a Pivot Table | Excel Worksheet Functions | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) |