As for getting a dynamic date range, you can use ADD_MONTHS(TODAY, -12). As for bringing in customers with $0, you'll have to make sure the criteria of the search doesn't exclude them. And in your results, you can nvl them, in case they are null.

NVL({transaction.amountnetoftax},'0')