Hi,
I have a sales sheet with multiple fields. I used a pivot table to help me create some visuals. The thing is, I need to update this sales sheet by the end of each month by adding the current month sales. I tried doing this manually by cutting the current month sales and pasting it in source data sheet. I refreshed the pivot tables I created and I could see the current month in the filters. The problem is, the charts didn't show the total sales and instead it showed the current month sales in a separate bar. Can you help me with that?

Check the screenshots.

Thank you,

Untitled.jpg

Untitled2.jpg

Untitled3.jpg

Untitled4.jpg