Report based on Request and two Requested Items

BuddhikaN
Tera Contributor

Hi All,

 

I'm struggling to create a report based on Request and Requested Items in SNOW and would you be able to help me with this please? 

 

In my case I have two Requested Items under one Request, and I need to create a report to show number of requests where one Requested Item is in Completed status and the other Requested Item is in Order Fulfillment stage. May I know is it possible? 

 

Thanks 

15 REPLIES 15

Hi @Amit Verma,

 

Unfortunately, it's not working that way and I believe it does not fulfil the below filtration too.  

 

RITM Item = ABC  AND  Stage = Completed

AND

RITM Item = XYZ  AND  Stage = Order Fulfillment

 

Thanks