Previous month sales

[kamielrajaram]

Hi all,

Please assist with generating straight table like below. 

I need to show the previous month value In line with the month end . Any suggestions. 

Month end     current month                  previous month
31/03/2019    25.91
30/04/2019    2 6.63                                        2 5.91
31/05/2019    2 .87                                          2 6.63
30/06/2019    224.15                                      2 .87
31/07/2019    271.29                                      224.15 

Thank you

Regards

Kamiel

[kamielrajaram]

Hi all,

Apologies,I thought it was resolved by using the above function.  But when I select a specific month end date I lose the value for the previous month. This has not been resolved.

Thank you

[sunny_talwar]

Try something like this

Above(Sum({<Month, MonthEnd, Date>}Sales)) * Avg(1)

Be sure to add all the date and time fields where you might make a selection. 

[kamielrajaram · Accepted solution]

Hi Sunny,

Thank you. I managed to do this in the script.

Kind Regards

Kamiel