Pivot table question
Hi I have a pivot table with some data. When I
put in the one of the fields "Costs" in the data area , excel does a count of the costs or if I go in options( Summary) it gives me choices for Sum, % of and etc. But I just want the values of the costs to show up in the pivot table data area but it does not give me that option .. I dont want any summarizing ( COunt, SUm, Min, Max ..etc) It seems I cannot find how to do that. Please help . Any suggestion is greatly appreciated. Thanks Yusuf. .. |
Pivot table question
A pivot Table does summarizing. The only way you can get the source values
individually is if you put in enough qualifying row fields that each combination describes a single record. -- Regards, Tom Ogilvy "Yusuf" wrote in message ... Hi I have a pivot table with some data. When I put in the one of the fields "Costs" in the data area , excel does a count of the costs or if I go in options( Summary) it gives me choices for Sum, % of and etc. But I just want the values of the costs to show up in the pivot table data area but it does not give me that option .. I dont want any summarizing ( COunt, SUm, Min, Max ..etc) It seems I cannot find how to do that. Please help . Any suggestion is greatly appreciated. Thanks Yusuf. . |
All times are GMT +1. The time now is 08:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com