Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
pivot table question | Excel Discussion (Misc queries) | |||
Pivot Table Question | New Users to Excel | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Worksheet Functions |