latest date vs last date sales price growth

[sayanpwc]

Hi friends,

Need a help urgently pls.

I have a data like this.

I have chart that shows date wise sales trend for each material based on material selection in listbox.

Now my requirement is to show for each product the % growth of sales from its latest date vs last date sales. and it will be shown on a text box on top of the gap between those dates.

So for ex: for product b sales growth % should be (700-600)/600*100 which is around 17 %

for product a this would be (400-200)/200*100 which is 100 %.

How can i do this?? pls help

[tresesco]

Select a product to see it's growth in text box. Text box expression like:

=

(     Sum({<sale_date={'$(=Date(Max(sale_date)))'}>}sale) -

     1/Sum({<sale_date={'$(=Date(Max(sale_date, 2)))'}>}sale)

)

*100