Sum Sales QTY by month

[LEGION]

Hello,

I need some help please, im trying to use the following formula to SUM up Sales Qty by rolling month,

(SUM({<TCODE={'IN'}, TXDATE={">=$(=date(addmonths(today(),-1)))"}>} QUANTITY))

What i want to see is my Total Sales Qty for Last month, then i will use the same formula to total 2 months ago, then 3 months ago.... problem is its not working 😞

TCODE = SALES TYPE

IN = INVOICES

TXDATE = TRANACTION DATE

[Kashyap_R · Accepted solution]

Hi 

Use RangeSum() Function 

or

 PFA

you can change directly in measure settings

Thanks