Creating a cumulative bar chart with additional categories

https://drive.google.com/file/d/1bHwAsEAM4Ry9AWiUIgcmSDF8iJdc8hNd/view?usp=drive_link

Hi,

Based on the data in the file, show the expected result in a Table format very clearly.

Sorry i messed up the data in the file i shared.
Here is a correct one:
https://drive.google.com/file/d/1bHwAsEAM4Ry9AWiUIgcmSDF8iJdc8hNd/view?usp=sharing

And this is what i need it to look like(with bars for each month instead of the three points of course):

So it always shows the accumulated monthly amount for each department and whenever there is an additional amount it just adds it to the amount of that department.
Also i might need it with a dynamic number of departments.

Thank you very much

I do not see 3 dots there.  Everything seems fine to me.

The image i sent is not the finished graph but only an edited version of what i want it to look like. Thats why i said the 3 dots in the image are only because i didnt want to create a bar for the months between april 2025 and january 2026. For practical reasons but they should of course be in the final visual.

For Dep 3, information is available only for JFM 2026.  There if i swap Year and Month on the X-axis, this is the image i get (with which i see nothing wrong)

Yes, but i need ALL of the monthly amount to be added up in every month after they are added.
In the ss you shared it resets after each year. I would like it to carry on the data from the previous years and departments.

Yes, thank you very much thats what i have been looking for.

You are welcome.