Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm trying to sum 12 values for each month, based on the "ThisMonth" values of the previous 12 months.
ThisMonth is just a sum: Sum(InvoiceQuantity)
And for the sake of this demo, I've been able to calculate "Prev Months" by:
RangeSum(Below(TOTAL Sum(InvoiceQuantity),1,12))
The problem with this, is that I'm stuck with this specific order. I want to remove this dependency.
Also, I can only calculate the RangeSum on values I'm displaying in the table. If I filter out a month, say ReportingMonth 9, then my "Prev Month" value loses that number.
I want to be able to calculate this sum, even if the months needed for the calculation aren't displayed in the table (filtered out, for example).