Saved Search to Display Quantity Sold per Month by Item

1. Go to Lists> Search >Saved Searches>New

2. Select Transaction

3. On the Criteria tab > Standard subtab > Add below Criteria:

a. Main Line is False/No

b. Type is Sales Order

c. Date is Relative from 12 months ago to 0 months ago

4. On the Results tab > Columns subtab > Add below Columns:

a. Item | Summary Type = Group

b. Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),0,{quantity})

c.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),1,{quantity})

d.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),2,{quantity})

e.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),3,{quantity})

f.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),4,{quantity})

g.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),5,{quantity})

h.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),6,{quantity})

i.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),7,{quantity})

j.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),8,{quantity})

k.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),9,{quantity})

l.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),10,{quantity})

m.  Formula(Numeric)  | Summary Type = Sum | Formula = DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),12,{quantity})

6. Hit Save and Run