Running Customer Value

I am trying to build a card that show our customers' running total value (for the last 365 days).

 

Here's the BM I have right now:

SUM(CASE WHEN `SO Ship Date`<=`SO Ship Date` AND `SO Ship Date`>SUBDATE(`SO Ship Date`,INTERVAL 365 DAY) THEN `SO Item Total Amount` ELSE 0 END)

 

Obviously though, when I graph it by month, I'm only getting the sum from the orders in each month. I would like to see the running total, just as of that month.

 

The ultimate goal of this is to see our different sales channels success, or more so, the health of their databases.

 

Any ideas?

Best Answer

Answers