Default selection for pivot table

[#1]

Hi All,

I like to have a default selection whereby when the qvw is open, the selection is always at Organisation as shown in Default.jpg. I thought I can use triggers in properties but it doesn’t seems to work for me. Please can you help?

Many Thanks!

Regards,

Heok

[#2]

Hi

pfa hope it will help

Regards

nirmal

[Aurelien_Martinez · Accepted solution]

Hi Heok,

In Document properties you can add trigger like that :

After change, save your QV file, close and reopen it.

Normaly it's working

Regards,

Aurélien.

[rustyfishbones]

Create a Bookmark

and then create an On Open trigger and call the Bookmark

[#5]

Hi

pfa

[#6]

Thanks for your screen shot. I add the action in the document properties and work now. I was adding the action to the sheet properties that's why it was not working early. Thanks again!