To do this click cell B4 and then type the following formula into the formula fx bar at the top of the sheet and then press Enter or Return. Select your tables data. If youd like to use a fancy color scheme follow along with this method to create your table.
You do not need to adjust your table if the new column is adjacent to the table.
On the Excel ribbon go to the Formulas tab Calculation group click the Calculation Options button and select one of the following options. In the Column input cell box enter the reference to the input cell for the input values in the column. Type the formula that you want to use and. Just click on any of the fields in your pivot table.