Using bookmark in the dimension of a chart

[#1]

hello

I am comparing sales of mobiles manufacturers (OEM) and i must only compare the sales of a few manufacturers only.

I have a list of OEMs like Nokia, samsumg, lg etc and i need to compare only the sales of three of them.

Instead of including the chosen OEMs in my set analysis each time, i have bookmarked these three selected iOEMs.

However, i want to use it in my chart dimension or expression without having to click on the bookmark list each time.

Is this possible and how to do it? Can anyone please help?

I have attached the qvw.

Thanks in advance

[#2 · Accepted solution]

Hi,

try to use something like this:

sum( {$*BM01} Sales )

See the help (Set Analysis)

C u,

Stefano

[#3]

Try this, i use the function above.

[#4]

Thanks a lot Stefano,

it works fine. I will try to use it in longer set analysis. Hope it works.