- Ignore Misread -

Sorry misread earlier, you need to pivot the data first if you have a date field and then once you get it into your new format, you create the column calculations between each time period.

Another way is by using formulae and choosing "(formula result)" in the aggregate drop-down. This avoids the need to de-pivot, but introduces fields into your data which are probably not relevant outside of the context of this particular in-view aggregation.

See attached; the formulas are commented clearly.

Hi Steve, the change % column seems to be only calculating the percentage of the previous figure over the next figure and not the change increase/decrease.

Could you revise the formula so that it divides the change figure over the previous Months Value figure please?

I have two columns: one containing the absolute delta, and one containing (current month / previous month). Isn't that what you want?

Well I don't know if that will suffice for hgross, I was just more interested to be able to get the change itself as a percentage of the previous value.

So it would be (Value2 - Value1) / Value1

Just so that it gives a positive/negative change value. I think I figured how to do that just by swapping the value field at the end of the "change %" column with the "change" value itself so Im good with that now

Thanks

By changing the value field with change value (like Daniel said), it gives the %up or %down... which is what I'm looking for. De-pivoting is also an interesting way to think about it.

Thanks guys!