How to keep previous bookmark data when replacing a bookmark?

[#1]

I have a bookmark BM01 which stores the selections:  ProductID = { 1 , 2 , 3 }

Now I want to replace this bookmark with a new selection: ProductID = { 4 ,5 , 6 } but i want to still keep the selection ProductID = { 1 , 2 , 3 } as well.

So, I want my new BM01 to be: ProductID = { 1 , 2 , 3 , 4 , 5 , 6 }.

How can I do this?

Thank you!

[jagan]

Hi,

Try like this

==Sum({$1} MeasureName) + Sum(MeasureName)

$1 for Previous Selections

Regards,

Jagan.

[#3]

Hi.

It works. Thanks a lot.

But is it possible to do this for more than 2 consecutive selections?

i.e. if I want to keep adding more and more selections while preserving all the old ones?

Thanks!

[jagan · Accepted solution]

Hi,

For second previous selection use {$2}, for third previous selectin use {$3}, ...n.

Please close the discussion by giving Correct and Helpful answers to the useful posts, if your requirement is solved it helps others in finding the correct answers.

Regards,

Jagan.

[#5]

Works. Thanks!