Reporting from multiple sheets

Jay Bautista

Is there a way I can run a report from multiple sheets? I can select 2 or more sheets but it's an "OR" and not "AND". So, the report isn't reporting on all selected sheets. Or, am I missing something? Thanks!

Stefan Siebenkittel

Jay,

reporting from multiple sheets is easily done by selecting the needed sheets from the "'Where?" box.

From your comment on "OR" and "AND", I guess, you probably talk about the connection between multiple criteria in the "What?" box, right?

You can switch between "OR" and "AND" by clicking on the horizontal line where it says "OR" or "AND" between the criteria.

 

Best regards

Stefan

Jay Bautista

Hi Stefan,

Thanks for getting back. I know the "What" enables you to select "AND" criteria. However, I'm interested in the "Where".

Stefan Siebenkittel

Hi Jay,

I still do not understand the problem, maybe you can provide an example?

Following scenario:

- 2 sheets with columns for "gender" and for "value".

- sheet1 with male names and numbers as value

- sheet2 with female names and characters as value

 

In the report I selected both sheets ("OR" between them) and then "gender" and "value" to be included. 

Data from both sheets appear in the sheet.

So "...the report isn't reporting on all selected sheets" looks strange to me ;-)