Add Running Total to Pivot Chart

[Dean]

I have a list of drawings with Issue Dates in a pivot table. I can display of
count of the drawins issued each month, but can not figure out how to create
a formula that will calculate the running total of the number of drawings
issued since the beginning of the project. I tried using sum(ytd, count) but
this just give me the running total for each year and I need to span multiple
years. This would be trivial in Excel, but I'm stumped in OWC. Would someone
please give me some advice on how to do this.
TIA

 

[Alvin Bruney [MVP]]

I thought about this, I don't know of an easy way to do it. You would need
to write a customized routine to produce that information. There is none
that I know of that will do this out of the box. The customized routine
would iterate the fieldsets performing the calculation as needed.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley