How to get the previous value in the Bar Chart?

[#1]

Hi Guys,

I am working on a Bar Chart with two dimensions, one is material, the other is date.

Material	Date	Inventory
M01	1st Jan	40
M01	2nd Jan	45
M01	3rd Jan	48
M02	1st Jan	60
M02	2nd Jan	92
M02	3rd Jan	70

I have created a Bar Chart based on this table and after the selection for material, the chart will be about date and inventory.

If i need to compare the value with its previous one, and mark the sharp change as another color, how can i fetch the previous value?

For example, for M01, 2nd Jan, i need to get 40 as it is the previous value for 45.

Could you please help?

Regards

[#2 · Accepted solution]

Got it. I added a field using Previous() to create previous value in the script.