Hi,

Please could you amend this query to only look at active categories, subcategories and items that have been used in the past month and have a count down of count per regions please? 

select cd.categoryname "Category",scd.name "SubCategory",it.name "Item",count(wo.workorderid) "Count" from itemdefinition it left join subcategorydefinition scd on scd.subcategoryid = it.subcategoryid left join categorydefinition cd on cd.categoryid = scd.categoryid left join workorderstates wos on it.itemid = wos.itemid left join (select workorderid from workorder where CREATEDTIME >= datetolong('2015-05-01') and CREATEDTIME <= datetolong('2016-02-29')) wo on wo.workorderid = wos.workorderid group by cd.categoryname,scd.name,it.name
order by 1, 2, 3

Thanks Lynne