Data filter issue

[priyanka1905]

HI,

I have a requirement for creating a webi report in which I have more than one rows for a particular invoice (Invoice number 12345). Lets say 4 rows for invoice# 12345 out of which 2 rows are having date month as May and rest 2 rows can have any other month, lets say April and March.

I want to include all the rows of invoice# 12345 in which even a single row is having date month as May.

Can anyone please help me how to achieve this?

If I am applying query filter on May month. It is including only 2 rows for invoice 12345.

[TammyPowlas]

Thank you for your question. Please note I updated your tag to Web Intelligence. Please be more careful when selecting tags in the future. Thank you

[former_member198519]

You can create a filter assuming that the date month objects is a date type object

= if((month([Month-date]) in ([Invoice]) = "May")) then "Show" else "Hide"