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…
