Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to understand how set analysis works.
It's not the syntax itself that puzzles me but rather how you can get results rolling on months.
For example I can get this to work:
=Sum({1
<%SaleEndDate = {">=01/05/2014<=31/07/2014"}>
} Account.DCF)
Now I cannot understand how to get a table where, for each month count buyers who purchased that month and the 2 months before, so:
Jan 2014 | Count buyers of Nov + Dec + Jan
Feb 2014 | Count buyers of Dec + Jan + Feb
Mar 2014 | Count buyers of Jan + Feb + Mar...
Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations