Formulas in a calculated field of Pivot Table

J

Jennifer

Ok, so heres the deal. I have a pivot table and I need to
create a field for "year to date". I want to create a
formula in the pivot table to figure:
1. Jan numbers +Feb numbers = YTDFeb.
2. YTD sum feb. + March numbers = YTDMarch
etc.

It would be very easy to create a column in my spreadsheet
to gain this info. but I really want to learn how to do it
in the pivot table.

Get me! Thank you for any help you can offer. Jennifer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top