sccardais

Challenging cross tab report

Discussion created by sccardais on Apr 25, 2017
Latest reply on Apr 25, 2017 by philmodjunk

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?

 

Outcomes