Thursday, February 04, 2010

Adding a calculated field in pivot table

The following are the steps to add a calculated field inside a pivot table in Excel

  • Click on a cell inside a pivot table.
  • Go the PivotTable Tools -- Options -- Click on Formula --Calculated Field
  • Add the formula for the calculated field
  • Click ok. This will add the calculated field to the Pivot table as well.

No comments:

Step By Step Guide to resolve SQL server connection issues when connecting from R Studio

Yesterday I tried using a couple of  RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio.  These are my learnings as part of ...