ExcelBanter - Setting up "Year to Date" Calculations in a Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Setting up "Year to Date" Calculations in a Pivot Table (https://www.excelbanter.com/excel-worksheet-functions/18670-setting-up-%22year-date%22-calculations-pivot-table.html)

Project64

Setting up "Year to Date" Calculations in a Pivot Table

I am using Excel 2000, is it possible to set up a "YTD" calculation within a
pivot table? If so, could you explain how?

Gary Brown

If your column header is Month, Total is your YTD. You can have only ytd by
hiding Month.
HTH,
Gary Brown

"Project64" wrote in message
...
I am using Excel 2000, is it possible to set up a "YTD" calculation within
a
pivot table? If so, could you explain how?

All times are GMT +1. The time now is 07:03 PM.