Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
You can place the sheets in different alternate states. Selections, and the objects on the sheet, will then be independent.
-Rob
Use alternate states as Rob Mentioned. From Doc properties create alternate states and use in current selection object.
Like