Filtering and comparing two month year

[Anonymous]

What I want to do here is this, I have 3 years worth of data and what to compare costs in any given month.

How do I get create a calculated column that will be the difference of Cost Per Kg (in the right) - Cost Per Kg (in the left)

So in the example below, I would want have a column there that would be called Cost Per Kg (difference)

Row 1 will then be 15.66-15.74

Could you please help me stalwar1‌ /swuehl‌?

Thanks.

[Anonymous]

Here is the app, I have been working on.

[sunny_talwar · Accepted solution]

My bad, you need After instead of Before

ceil( Sum([Total Amount])/Sum([Actual Weight]),0.01) - After(ceil( Sum([Total Amount])/Sum([Actual Weight]),0.01))

[Anonymous]

Thanks Sunny!

[Anonymous]

sunnysahni‌‌, I have a followup question.

Is there a way to hide the last column?

[sunny_talwar]

No straight forward way to do this, but there can be work around to do this

[Anonymous]

How do I do it?