Excel 2007 : Pivot Table Values Don't Want Sum's or Avg's I want an ACTUAL No.

[melfricke]

I'm looking to show an actual CPC for my primary row label I don't want an average or a % of row. I want to show actual values for each publications. I've attached a copy of the spreadsheet and at each site subtotal line and for the grand total I would like to show the actual CPC and CTR.

I really appreciate the help.

[Azam Ali]

This can be done thourgh the forumula option in the pivot table menu

i ve added two formulas in the enclsoed file. hopfully it works