Hi,
I have two calculated data items on my report "Daily Shipped" and "AVG cases Per Line". Users want to filter the report to only display records that have "Daily Shipped" > "X" AND "AVG Cases Per Line" > "Y".
I created two text box prompts and when I enter values, the "Daily Shipped" will produce the correct results but "AVG cases Per Line" may be a value less than what I am expecting. Is there a way to make 2 text prompts dependent on each other similar to a cascading prompt for a value prompt?
Or is there a better approach to go about this?
Thanks
How is/are the filter(s) defined? I'd guess either an incorrect operator, or incorrect timing (before aggregation vs after aggregation).
Cheers!
MF.