Report: with 2 sheets

Rikap
โญโญโญ
Hello!
I am trying to create a report with 2 sheets, if I try and filter one particular column, the data is only being pulled from one sheet and not the other, is there a way to fix this?
Answers
-
Play around with the filter groups. You should be able to say something like, if sheet name contains SHEET1 and Field Name is one of EXAMPLE, OR sheet name contains SHEET2. And just play around til you get what you need.