To change the rate in different table, Click on Pivot table then on tool bar 'PivotTable Analyze' menu will appear.
Go to PivotTable Analyze=>Fields, Items &Sets=>Insert Calculated Field=>In drop down you will find Rate
You can also have different table for Rate which you can use to pull data to this table.
Bookmarks