Access pivottable running total

  • Thread starter William E Hannon Jr
  • Start date
W

William E Hannon Jr

I have successfully created a calculated field in the Access pivottable from
a union query,
but I would also like to create another field with a running total from the
calculated field.

Is there anyway to create a running total field in Access?
I am looking for the functional equivalent to Excel
Field Settings->Options->Show data as:->Running Total In->(choose Base
Field)
 
W

William E Hannon Jr

Almost there found

Sum (YTD(), [Measures].[Delta])

Which gave me running total for the year .... still looking for the full
running total.
 
Top