happyhungarian
Active Member
- Joined
- Jul 19, 2011
- Messages
- 254
- Office Version
- 365
- Platform
- Windows
Hi, I need help with adding a Grand Total to my pivot table. I'm trying to add a "Year to Date" column in my pivot table. The way my data source is set has each month being reflected as its own Field. Therefore the basic Grand Total won't work. I also dont want to have to create a "Year to Date" section within my data source because that would affect other parts of my report. I also want to avoid having to do a Calculated Field because then my report wont be dynamic since I would have to update the Calculated Field each month to capture the new month. Is there an easy way around this?
Thanks
Jesse
Thanks
Jesse