Accumulating monthly totals

  • Thread starter Thread starter Connel Valentine
  • Start date Start date
C

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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top