Current selections box shows filters made in another sheet

[loyarcec]

Hello!,

   Hope somebody can help me with this please.

   I have a report with two sheets and each one of these is populated with data coming from different excel files (NoConcatenate); the problem is when I choose a filter in the second sheet, the 'current selections' box add up the filter of that one.

is there a way of keeping independent each one?

Summary:

ExcelFileA  --> Sheet A  --> Current Selections Box A

ExcelFileB  --> Sheet B  --> Current Selections Box B

See attached.

Thanks!

[c_gilbert]

You could put a trigger on the sheet so when it is activated, it either clears all selections, or you can specify which field to clear.

[rwunderlich]

You can place the sheets in different alternate states. Selections, and the objects on the sheet, will then be independent.

-Rob

[vishsaggi]

Use alternate states as Rob Mentioned. From Doc properties create alternate states and use in current selection object.

Like