I would like to create a report similar to the one shown on the left side of the screenshot below. The two boxes on the right represent the tables and source data fields.
After setting 2 global date fields, and starting from a layout based on PRODUCTS, I want to compare the total number of customers for each product and calculate the difference.
The total number of customers for each product is a calculation field using the DATA: date_ordered and DATA_date_canceled. For example, the value for Product A under global date 1 would be calculated by counting all customer ids for orders received before global date 1 and subtracting a count of all customer ids for orders canceled before global date 1.
Can anyone suggest how I might accomplish this?