I am working on a Bar Chart with two dimensions, one is material, the other is date.
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?