Jump to content

How can I calculate the cumulative difference between side-by-side bars in a bar chart


Niki Nichols 2

Recommended Posts

I am taking large amounts of raw daily gas volume data and aggregating it to compare against my forecasted volume data. I have made a side-by-side bar chart comparing my actuals vs. my forecast for any given month. I want to make this a combination chart that has a cumulative year-to-date variance calculation that showsTotal Actual Volume - Total Forecasted Volume.

Can I do this with a custom expression I've attached a photo below of the data I have. In January, my custom expression should = 1,272,986 - 1,268,523 = 4,463. In February, my customexpression should = 4,463 + (1,290,170 - 2,042,977) = 4,463 + (-752,807) = -748,344. Meaning I am 748,344 units below my forecasted volume so far for the year.

 

Help! Thank you in advance!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...