Multiple Text Prompts - Dependent on each other

[johnmabe]

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

[MFGF]

How is/are the filter(s) defined?  I'd guess either an incorrect operator, or incorrect timing (before aggregation vs after aggregation).

Cheers!

MF.