Variance Column as Part Of Pivot

Hi All

I am importing data into excel from a sql table and then creating a pivot based on this data (SEE BELOW EXAMPLE). I have created a manual column which adds the tonnage for each week and then subtract the budget from this total (to give the variance).

This works fine until for example we come into the new month which may have 5 weeks (as opposed to 4 in the previous month), which in turn means an extra column. The extra column then overwrites the variance column. Is there anyway I can get the variance to be built into the pivot? Please see below example:

REP Budget Late 2017-12-11 2017-12-18 2017-12-25 Invoiced Variance
XX 100 10 10 10 10 -60
YY 200 20 20 20 20 20 -100

Thanks In Advance

Thank you for your response, I have added an example.

Exactly what I wanted and will click on the enhance reputation, only issue is we have 365 business version and having had a look online, this add-in is not available on this version!

Sorry - re-opened this... I now have the version with power pivot and the above has really helped create additional reports. What I don't understand and apologies if this is really simple, in the above example there is simple one column in the pivot table which shows the total for potential. I am not sure how this has been placed in the pivot.

I have created the measures in my report, however get a figure for potential for each monthly status as opposed to a total of potential as in above solution. How did you get this?

Hi I did try that but I also get a grand total for Actuals Value

Actuals Value Total Actuals Value Total Potential Value Total Variance Value
Budget Late Invoiced 2018-02-05 2018-02-12 2018-02-19 2018-02-26

Apologies and thank you ever so much for your time. I have turned off grand totals for rows but this also gets rid off the potential and variance columns as well as the Total Actuals.

Sorry

Not trying to be lazy - honest! I did create the measures like yourself, but I don't know how to get the variance and potential like you did, really appreciate your assistance - thanks ever so much.

Reverted back to original formulas (although there will be times when there is only one value for shortfall status and this wont show the totals correctly), removed totals for rows and potential and variance columns are disappearing as per above.

I totally agree, tried recreating the pivot again, copying the formulas you provided for actuals value, budget and potential, but they only way potential value is showing is if I have row totals on, but this then shows total for actuals which is not what your example is showing (which incidentally is exactly what I want.. I am confused will try to figure it out, but thank you ever so much for your time.