Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 6th 08, 09:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 58
Default 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   Report Post  
Old November 6th 08, 11:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2,389
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Divide 2 pivot table numbers DANM Excel Worksheet Functions 3 March 31st 08 11:09 PM
Pivot Table exclude negative values from sum momto2 Excel Discussion (Misc queries) 2 November 19th 07 01:23 AM
Pivot Table formatting numbers Jock Excel Worksheet Functions 2 August 10th 07 04:30 PM
Negative Numbers in a Pivot Table PB Excel Worksheet Functions 1 July 9th 07 10:46 PM
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017