Case statement

[sujitgouda]

I have a field called Regions which has values: BD. EDJ and WH
I have a field called Territory which has a value: MF, MAG, SMA

While using cascading prompt I don't want BD and WH to include MF. Only when I filter out EDJ I should be able to see MF and the query set should filter out data for the same.

How do I do this ?

[sujitgouda]

This is done.

Changed the data item to show the value only when the ?parameter_1?= 'EDJ'

Thanks.