sccardais

Help Creating a Report

Discussion created by sccardais on Oct 9, 2015
Latest reply on Oct 9, 2015 by sccardais

I'd like to create a report showing New Orders and Cancelations by Year - Month for 7 different products.

 

My table ORGS has fields identifying the Product, Date_Ordered and Date_Canceled. It also has separate calc fields converting Date_Ordered and Date_Canceled to the YYYY_MM format as shown below. For each product, I want to show the count of orders received that month and the number of cancelations received. In addition, I'd like to show the cumulative number of orders received (column C), Cumulative number of Cancelations (column E) and the cumulative cancelation rate (column E / column C).

 

I'm having trouble consolidating the data to create this report because there isn't a single Report Period field to sort or match.

 

Am I missing something obvious here?

TEMP_Count_by_Year_Month.png

Outcomes