Solved
How to Calculate YTD by Month in a pivot table
I have a pivot table that works for my team. It looks like this:
The variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget).
I have received...
Hey oliviar ,
If you want to show YTD by Month next to your monthly amount you can utilize the "Running Sum" Quick Calculation. If you want to show this next to the monthly amount, just bring in that same value again.
If you just want to show total for the time period you can use the "Grand Total" on columns
Hope this helps
