Pivot table - data

  • Thread starter Thread starter Yusuf
  • Start date Start date
Y

Yusuf

Hi I have a pivot table with some exhaustive data. When I
put in the one of the fields "Costs" in the data area ,
excel automatically does a count of the costs or if I go
in options it gives me choices of Sum, % of and etc. But
I just want the basic value of the costs to show up.. no
calculations> it seems I cannot find how to do that.
Please help asap.

Thanks
Yusuf.
 
The idea behind a pivot table is to provide a summary of
single items of data grouped into counts or sums etc. You
can get around this by placing your column COSTS in
either the ROW or COLUMN sections. This will provide you
with a separate row or column for every individual cost
you have. Use a field that you can count with in the DATA
area.
 
Back
Top