Launch a sheet with 2 initial selections in the same dimension

[Anonymous]

Hi Guys,

On a sheet load I need a filter to be set as Client Status = 'A' and 'B' (In this case only active Clients will show). Therefor I am using the Climber Selection bar but here only one initial selection is possible or am I wrong? So how can I open the sheet with an initial selection of two of the three values of a dimension?

Thanks in advance.

[rubenmarin · Accepted solution]

Hi Robbert, the extension allows to set a separator for many values, default separator is comma, so you can set the value as:

A,B

[Anonymous]

Thanks Ruben,

I was constantly doing it between single quotes since it were words.

It works!

Thanks!

[lanlizgu]

Hi Ruben

I am experiencing the same issue, but when I add to the initial selection the two values I would like to get 40575,40576

I get an error in the expression. The initial separator is also set as a comma.

Thank you.

[lanlizgu]

I got it, I had to add '40575,40576'.

Thank you