Need a formula to add diference column

[Waqas Gul]

Dear Experts,

need your help in attached sheet. i have created purchase vs consumption sheet date wise from which i summarize code wise and month wise purchase vs consumption. these are done but i need a difference between every day purchase of that codes vs consumption. how do i do this? i tried my best but i cant. that's why i came to ask from experts if anyone can help me to pull out from this problem.

i have a data sheet on which i insert pivot table slicer and timeline but i also need a difference column which i don't know how?
also please if someone can tell me can i design a timeline with columns not cursor moving?

if something not understand i will share more detailed.

Thanks

[Waqas Gul]

if anything not understand i can explain more,
i need code wise monthly difference between purchase and consumption, which code how much purchase in the month JAN and how much consume in the month JAN. i am not clear if this is possible to add the difference column in this table or how to add the difference? i want the difference on total in pivot not date wise.
and the 2nd thing i want the timeline design to change is it possible that Timeline design also show in columns? not on scroll to side?

Thanks

[JeteMc]

As to finding a difference, I believe that the following, placed in H4:H200 of Sheet4, may work: =IF(OR(A4="",A4="Grand Total"),"",C4*D4-E4*F4)
If that doesn't produce the expected results then it would be helpful if you could manually include a few of the results so that we can see what the formulas/code should yield.
Let us know if you have any questions.

[Waqas Gul]

That's great Thanks JeteMc for your help. I need the Quantity Difference in one column (Purchase - Consumption) and the Amount in another column. if you can help me in this regard's

[JeteMc]

The amount difference is as given in post #3.
The quantity difference is: =IF(OR(A4="",A4="Grand Total"),"",C4-E4)
Let us know if you have any questions.

[Waqas Gul]

The amount difference is as given in post #3.
The quantity difference is: =IF(OR(A4="",A4="Grand Total"),"",C4-E4)
Let us know if you have any questions.

Really appreciated Thanks its work fine, last thing which is missing, how do we add subtotal for the differences column we add manual. when we select months from time line, is it possible that the difference columns show totals?

[JeteMc]

Please show us an example of where a subtotal has been manually added to the difference column as described in post #6.
Let us know if you have any questions.

[Waqas Gul]

here i have attached the file, on the place of yellow highlighted.

[JeteMc]

Paste the following into cell G4 then double click the fill handle to copy down: =IF(A4="","",IF(A4="Grand Total",SUM(G$3:INDIRECT(ADDRESS(ROW()-1,COLUMN(G1)))),C4-E4))
Paste the following into cell H4 then double click the fill handle to copy down: =IF(A4="","",IF(A4="Grand Total",SUM(H$3:INDIRECT(ADDRESS(ROW()-1,COLUMN(H1)))),C4*D4-E4*F4))
Let us know if you have any questions.

[Waqas Gul]

Paste the following into cell G4 then double click the fill handle to copy down: =IF(A4="","",IF(A4="Grand Total",SUM(G$3:INDIRECT(ADDRESS(ROW()-1,COLUMN(G1)))),C4-E4))
Paste the following into cell H4 then double click the fill handle to copy down: =IF(A4="","",IF(A4="Grand Total",SUM(H$3:INDIRECT(ADDRESS(ROW()-1,COLUMN(H1)))),C4*D4-E4*F4))
Let us know if you have any questions.

Really appreciated, Thank you so much. Solved.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.