Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Bookmark aaa, where I select Client cc.
I want to see different color for it in a chart.
Or how can I see different color just for 1 client?
I attached a simple file as an example.
Thanks,
On your chart, add a background color expression for your first expression:
=if(Client = only({BM01} Client), lightred(), blue())
Your chart should then color whatever is in your bookmark red and everything else should appear blue.
in the 1st expression for the background color chenge the expression to
=if (getselectedfiedl(client)='aa', rgb(255,255,0), rgb(255,0,0))
yes, but client is changed dynamically.
try this
=if (getselectedfiedl(client)='aa', rgb(255,255,0),
getselectedfiedl(client)='bb', color2
getselectedfiedl(client)='cc', color3)))
Not in my case. I have thousands clients
Try this for color expression:
=if(GetSelectedCount(Client)>0,
if(match(Client ,concat(distinct Client, ', ')),rgb(255,0,0),rgb(10,100,0))
,
rgb(10,100,0))
This will highlight the selected clients in red.
It may also make sense to change Result and res to ignore selections in this case:
avg({1}Result)
Sum ( {1}[res])
you can create variable vclient= client
and it the expression back ground write if( client ='$(vclient)',rgb(255,255,255),rgb(0,0,0))
something like this. when ever u select a different client then respective colors are shown up.
hope this helps
On your chart, add a background color expression for your first expression:
=if(Client = only({BM01} Client), lightred(), blue())
Your chart should then color whatever is in your bookmark red and everything else should appear blue.
Thanks for idea, It works.
How can I manage dynamically bookmark? I want to set up a trigger on leave sheet.
Thanks all you guys,
Can you further explain what you would like your dynamic bookmark to do?