Hide current selections in a tab

[venkatg6759]

Hello,

Is there a way where we can hide current selections and show the entire data in a tab without taking the previous selections in another tab?

[MayilVahanan]

Hi

You can exclude that selection by using set analysis like

=Sum({<Year=>}Sales) // it excludes the year selection

Sum({1}Sales) // it excludes all selection

[Andrea_Ghirardello]

Try using bookmarks.

See attached qvw in the following discussion:

Retaining Selections using bookmark or macro

[yavoro]

Hi, the only thing I can think of is to clear all selections when you go to this tab.

You can set up an action in tab triggers for that.

Hope that helps.

Regards

[#5 · Accepted solution]

If you go to the sheet properties of the tab.

And toy choose the tab triggers.

You can add an action to OnActivateSheet.

From selection just add Clear All and all selections will be dropped

[venkatg6759]

Thanks Erik. It worked perfectly.