Saved Search Displaying Number of units Sold per 6 Month and Months in Columns

Assume that you want to show total Sales per Month listed per Column for 6 months and a year from today.

1. Go to Transactions>Management>Saved Searches>New
2. Select Transaction
3. On the Criteria tab add Main Line is False, Type is Sales Order and Date is Relative from 12 months ago to 0 months ago
4. On the Results tab add Item with Summary Type = Group and the following Formula(Numeric) with Summary Type = Sum
   • DECODE(TO_CHAR({today},’MM’) – TO_CHAR({trandate},’MM’) + 12*(TO_CHAR({today},’YYYY’)-TO_CHAR({trandate},’YYYY’)),5,{quantity})
   • DECODE(TO_CHAR({today},’MM’) – TO_CHAR({trandate},’MM’) + 12*(TO_CHAR({today},’YYYY’)-TO_CHAR({trandate},’YYYY’)),11,{quantity})
5.  Save and Run

in Result