Pivot Table & running total (2000k SP1)

Topic

New Reply

Folks,

I am looking for a way to obtain running totals in Pivot Tables. I am pretty sure it can be done but I can’t figure out how

Reply | Quote

Replies

alex,
Right-click on your totals field, select ‘Field Settings…’, Options, select ‘Running Total in..’ from the ‘Show data as’ dropdown, then select Month in the Base Field list. Something close to that should work for you.

graeme

Reply | Quote

Thanks – exactly on the money !

–alex

Reply | Quote