Pivottable Sum of fields.

[Saviz]

Hi,

Pivittable report out put:

Week Acknowledged Open Closed
1 2 2 1
2 5 5 6
3 1 2 2

How can I achieve this?

Sum(Open + Acknowledged)
Week
1 4
2 10
3 3

In other words how do I add another field to display sum Open + Acknowledged
in the same pivottable..so after the closed field I want to display Open +
Acknowledged for each week.

Thanks,

Sav

 

[Dave Peterson]

I'd start at Debra Dalgleish's site:
http://contextures.com/xlPivot10.html