Report based on Request and two Requested Items

[BuddhikaN]

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 

[BuddhikaN]

Hi @Amit Verma,

Unfortunately, using AND does not give me any data in the report. Is it possible to use following filtration in SNOW? 

Requested Item = ABC AND Stage = Completed

And 

Requested Item = XYZ AND Stage = Order Fulfillment

If the above is possible I think I would be able to generate the report without any issues. 

Thanks

[BuddhikaN]

Hi @Amit Verma,

Unfortunately, using AND does not give me any date for the report.  

If I can use the below filters in SNOW, I think I would be able to generate the report without any issues and may I know is that possible and if so how can I do that? 

RITM Item = ABC  AND  Stage = Completed

AND

RITM Item = XYZ  AND  Stage = Order Fulfillment

Thanks

[Amit Verma]

@BuddhikaN 

If that is the case, you can apply the above filters as shown below :

[BuddhikaN]

Hi @Amit Verma,

No this won't give any data. Have tried this with yourself? 

Thanks

[Amit Verma]

@BuddhikaN 

No. I haven't tried this yet. I just made this filter as per the requirement you gave in your previous response.