Help with MoM figure

[tom906123]

Hello,

I am trying to create a table and a separate line graph to highlight MoM growth rates.

I have the below data:

OrderDate | Month# | Client | Sales

2018-03-16    3   abc123   $1,000

2018-03-18    3   xyz123   $1,500

2018-04-10    4   abc123   $2,000

2018-05-13    5   xyz123   $3,000

Total sales for March = $2,500

Total sales for April = $2,000

Total sales for May = $3,000

I would expect the first value to be null seeing as no data exists for February.

Any help would be much appreciated!

[Nicole-Smith]

Dimension:

=MonthName(MonthStart(OrderDate))

Expression:

(sum(Sales) - above(sum(Sales)))/above(sum(Sales))

Result:

[tom906123]

Thanks very much - worked perfectly!