Compensation and Adjustments of Quantities

[bhorparag96]

Hello Team,

I am facing a challenge. I need help as I need to make the Utilization as near as 100% of all the columns and sum of quantities should not change across the row. It means that if I reduce a quantity from 1 particular column (Date Columns) then I should also add that amount of  quantity somewhere in same row but different column. Should keep on doing this until Delta quanties are near to 0 and utilization is near to 100% . We have to adjust quantities in multiples of 23 and make "Total Units" (which is the sum of whole column) equals to "Capapcity". 

Eg:-   As we can see we need to substract 253("Delta") quantities from whole column of "K"(12-06-2023)  and need to add 459("Delta") quantities into column "L"(19-06-2023) to match "Totals units" with "Capacity" of column "K" & "L". So lets assume I reduce 92 quantities from cell "K12" then I also need to add 92 quantites at same time in cell "L12". Keep on doing this pair operation until all the columns Total Units match with "Capacity"

1)Data before Adjustments (Raw Data)

2)Data after adjustments

This 2nd Image is the expected final Output.

I have also attached the file for reference.

Kindly let me know your suggestions to achieve this operation.

[geraldo]

@bhorparag96 

from your illustration I could not understand your challenge could you exemplify better because this way in pivot table it was not clear

[bhorparag96]

Hi ,

I have added more details in my question. Kindly let me know your sugesstion please.