View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fen
 
Posts: n/a
Default Can I do calculations on already calculated fields in a pivot tabl

I have already calculated a pivot table that has Total Volumes and Total
Costs as fields in it. Can I do a further calculation within my pivot table
on these calculated figures to calculate the Unit Cost = Total Volumes/Total
Costs? Or can you only do calculations on the orginal data not on the
calculated fields?

Thanks,
Fenella