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
Bookmarks