Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have an excel with sample format and numbers for Actual and Budget. I need cumulative addition of Actual, Budget, Actual-Budget and the variance calculations till the current month(for YTD) , in the sample example its 'Apr'. And rest of the columns in pivot (Average Actual and Budget- actual )only for YTD month that is Apr only. so first four column for all the months till April(with cumulative values for the fields) and next two columns only for the month of April.
Any help will be appreciated.
Thanks
Shraddha
Shraddha
It might be easier to help if you are able to share the app where you are trying to do this.
Hello, Can you help with this business requirement?
Excel is attached with sample data and expected output.
Thanks much always!
Shraddha