Using a Pivot table insert rows to enter projected data

Question

I have departmental expenses data as Pivot table. The rows contain the type and description of expenses and the columns have the months across. I want to utilize the data and populate a projection for the next year budget. I know that I can insert rows in a Pivot table but data could not be entered. What is the best way to accomplish my needs?

Thanks for the advice.

Answer 1

Drag and drop the fields under PivotTable Field list and the sort it or filter it accordingly.

For more information on this check the link below:

http://office.microsoft.com/en-us/excel-help/use-a-pivottable-report-to-make-external-table-data-available-in-excel-services-HA010207979.aspx?CTT=1

---

Ruchi Bisht