Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Dimension:
=MonthName(MonthStart(OrderDate))
Expression:
(sum(Sales) - above(sum(Sales)))/above(sum(Sales))
Result:
Thanks very much - worked perfectly!