Accumulating monthly totals

[Connel Valentine]

In a pivot table, how can you display a monthly cumulative
value of a field in the y axis with the months in the x
axis?
i.e.

x y
Jan = 5
Feb = 8 (i.e. 5(Jan) + 3(Feb))
Mar = 12 (i.e. 5(Jan) + 3(Feb) + 4(Mar))

Thanks

 

[[MVP] S. Clark]

Although Pivot tables are like queries on steriods, I do not ever recall
seeing this capability. It doesn't mean that it doesn't exist, but you may
want to try posting your question in the m.p.SQLServer.OLAP or DataWarehouse
newsgroup, as they use PivotTables on a regular basis.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-