topic Re: Filtering and comparing two month year in App Development

Filtering and comparing two month year

Anonymous — Wed, 21 Feb 2018 01:20:16 GMT

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.

Re: Filtering and comparing two month year

sunny_talwar — Mon, 26 Feb 2018 12:36:57 GMT

May be using Before function

CostPerKgExpression - Before(CostPerKgExpression)

Missing Manual - Before() and After()

Re: Filtering and comparing two month year

Anonymous — Mon, 26 Feb 2018 12:41:51 GMT

Thanks for the response. How do I do generate the calculated column in the pivot table?

Re: Filtering and comparing two month year

sunny_talwar — Mon, 26 Feb 2018 12:42:51 GMT

Not sure I understand your question?

Re: Filtering and comparing two month year

Anonymous — Mon, 26 Feb 2018 12:52:19 GMT

I was hoping to create a new column in the pivot like below. Thanks.

Re: Filtering and comparing two month year

sunny_talwar — Mon, 26 Feb 2018 12:56:26 GMT

Just add a new measure like this

CostPerKgExpression - Before(CostPerKgExpression)

Make sure to replace the CostPerKgExpression above with the expression you have for CostPerKg..

Does this make sense?

Re: Filtering and comparing two month year

Anonymous — Mon, 26 Feb 2018 13:04:13 GMT

Cost Per Kg is actually Cost/Weight.

When I added measure of Cost Per Kg Delta with Expression: ceil( Sum([Total Amount])/Sum([Actual Weight]),0.01)-Before(ceil( Sum([Total Amount])/Sum([Actual Weight]),0.01))

The other month would not show up, this is how it looked like

Re: Filtering and comparing two month year

sunny_talwar — Mon, 26 Feb 2018 13:06:28 GMT

You still have 2017-02 selected for your chart right?

Re: Filtering and comparing two month year

Anonymous — Mon, 26 Feb 2018 13:08:39 GMT

Yes. I still have it selected.

Re: Filtering and comparing two month year

sunny_talwar — Mon, 26 Feb 2018 13:13:51 GMT

Not sure... would you be able to share a sample?

Re: Filtering and comparing two month year

Anonymous — Mon, 26 Feb 2018 13:38:08 GMT

Here is the app, I have been working on.

Re: Filtering and comparing two month year

sunny_talwar — Mon, 26 Feb 2018 13:42:57 GMT

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))

Re: Filtering and comparing two month year

Anonymous — Mon, 26 Feb 2018 13:47:58 GMT

Thanks Sunny!

Re: Filtering and comparing two month year

Anonymous — Fri, 02 Mar 2018 03:20:07 GMT

sunnysahni‌‌, I have a followup question.

Is there a way to hide the last column?

Re: Filtering and comparing two month year

sunny_talwar — Fri, 02 Mar 2018 09:58:00 GMT

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

Re: Filtering and comparing two month year

Anonymous — Fri, 02 Mar 2018 10:38:00 GMT

How do I do it?