Here is what I have. Newbie user. What I want is for it to look like my excel graph without so much of the manual data entry. the raw file the data is pulled from is attached. I had to remove a bunch just because of our sharing rules but the essential data is there.
I want the annual budget month by month and performance to budget on the right axis cumulative for the year. and then each month on the left axis separately. I will likely split up by category month by month only.
Questions as follows:
How can i get a second axis showing cumulative annual budget? In excel manually tabulated from all monthly spends. need to write formula but just took this over and have not done yet.
How can i show monthly cumulative performance to budget line? Also manually tabulated currently.
Not concerned with the 2019 line in the shown graph.
Thanks in advance!
I guess it is the 2019 version
The reason I am asking is the "Budget" column does not show up after my right join.
did you use a calculation to come up with that one? in the latter part of your explanation it shows
that Sum of Fixed budget per week relies on this column. but i missed how you came up with this column.
Thanks,Jason
