Reporting condition - only show when 2 conditions are match

[edneyimme]

Hi all, we create one App Engine, and we build one report where we are grouping the source, and we can to show the results only when 2 categories are in this Source like Software = Windows and Software = Office.

in case one of this conditions aren't match, the data should not be visible.

This is not related to SAM ok. ist just a example. 

[J Siva]

Hi @edneyimme 
what's the type of the Source field?
Is it list or reference type?

Regards,
Siva

[edneyimme]

Is a String field. 

[Ankur Bawiskar]

@edneyimme 

so you created report with the filter condition as below

Source like Software = Windows and Software = Office.

share some screenshots of the table field, report conditions etc

If my response helped please mark it correct and close the thread so that it benefits future readers.

[edneyimme]

thanks for sharing your answer, maybe i should give more details. 

I have one Source table, 

i have on table - Category which can have multiple entries, which can have many to many relation

i have another table with metric, where has 1 to x 

i should only show in report some data in case in the metric table 2 entries are there, for 2 separate category.