Frequently Asked Question

Subject:	Can I multiply two columns in a report to create a total column?
Status:	Publish
Category:	Data Warehouse, Tracker Office, Tracker Suite
Request Type:	Data Warehouse, Tracker Office 2.2, Tracker Office 2.3

1) Export to an Excel Spreadsheet, add the column with a formula, save the spreadsheet on a drive in Excel format, and set it to update from the original data source (SQL).

or

2) Click on the blue bar above the pivot table and paste that into an Excel Spreadsheet and add the column. This will not allow you to update from the original Data source, but looks a little nicer.

---

Not in the Report. You can:
1) Export to an Excel Spreadsheet, add the column with a formula, save the spreadsheet on a drive in Excel format, and set it to update from the original data source (SQL).

or

2) Click on the blue bar above the pivot table and paste that into an Excel Spreadsheet and add the column. This will not allow you to update from the original Data source, but looks a little nicer.