Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot tables

ResolvedVersion 2003

Tracie has attended:
Excel Advanced course

Pivot tables

Is there a way to use data in Pivot tables so that totals accumilate. e.g. On a monthly/yearly basis?

RE: Pivot tables

Hi Tracie

Thank you for your question. Yes it is possible. Right click on your data field and from the menu choose Field settings. From the Show data as menu select "Running Total in" then choose the Basefield column. This must either be in the row (or column) area rather than the data section of your pivot table e.g. date.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Fri 2 Oct 2009: Automatically marked as resolved.

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.