Current selections box for current sheet only

[#1]

Hi all - I have a bit of an unusaul data model due to customer requirements.

I have sales data split by region and each region has its own table in the data model which is qualified so there are no joins.  Then in my application there are several sheets showing the sales by each region.  This is so different selections can be made on each region sheet and not affect the other sheets/regions.

The problem I have is the Current Selections box on each sheet is showing the selections across all sheets.  I only want it to show the selections that have been made on the sheet the selection box is in.

Is there a way to do this?  Or maybe to create a text box or other object to display only the selections on each sheet?

Thanks in advance.

S.

[tresesco · Accepted solution]

Try using Alternate State (QV11). PFA for sample

[nizamsha]

in setting--> document properties-->general tab->alternate state button is there -------->add the alternate state name then go to the sheet add the alternate state name to field

for eg country is the field for that u want to create a alternate state mean put the country listbox first make a copy of country listbox in that give the alternate state name 

[#4]

Thanks both - I will try the alternate states function.