Hello -- I hope someone can help me with a Pivot Table Calculation Field problem I worked on it, for hours today.
Table has 3 columns
1. Dept# (text)
2. Type of amounts (text) 5 Types = Budget, Grant, Infrastructure, Projects, Technology
3. Amounts (currency)
Pivot table
- Rows = Dept#
- Columns = Type
- Values = Amounts
There are 5 columns of amounts. I want to calculate (Budget + Grant) -(Infrastructure + Projects + Technology) Can this be done in the Calculation field?
Attached is a worksheet illustrating this quandary.
Thank you for thinking about this problem
BTTFin
Bookmarks