Sum in Pivot Table
 

My Data:

All 4 of the following columns are located in the row area of the pivot table.

Vision | Rollup | Project | Money
001| Rollup 1 | project 1 |$200
| Rollup 2 | Project 2 |$100
| Rollup 3 | Project 3 |$500
002| Rollup 4 | Project 4 |$100
| Rollup 5 | Project 5 |$20

How can insert a calculated field that would sum all the money for vision
001, then for 002.

It would be ideal if I can have a sum of money on the same line as 001
(instead of line after rollup 3.

Thanks

Sum in Pivot Table
 

anyone?

"TheVedek" wrote:

My Data:

All 4 of the following columns are located in the row area of the pivot table.

Vision | Rollup | Project | Money
001| Rollup 1 | project 1 |$200
| Rollup 2 | Project 2 |$100
| Rollup 3 | Project 3 |$500
002| Rollup 4 | Project 4 |$100
| Rollup 5 | Project 5 |$20

How can insert a calculated field that would sum all the money for vision
001, then for 002.

It would be ideal if I can have a sum of money on the same line as 001
(instead of line after rollup 3.

Thanks