Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys and girls
i Need to accumulate the Sales of the 2 last months. here and example in QlikView...Is very easy because i have the option but how do i do this in QSense??
As you see, For example the sales in month 5 are 500, but the acummulated of the 2 last months is (300+400+500) 1200. How do i do this in Qsense?? Need Set Analysis? There is an option like this one?
Thank you very much
May be using RangeSum(Above())
RangeSum(Above(Sum(Sales), 0, 3))