I have 2 cross tabs. I want to pull all breakdown work orders in one cross tab and all Preventative maintenance orders in another cross tab. I want both cross tabs to use the same date range that is chosen on the prompt page. How do I do this? One cross tab wont let me filter data without the other cross tab becoming affected.
Whoops, I just didn't have the Aggregate function set to total.