Show Unrelated data In Chart

[#1]

When we select data in selection field, its shows all value but in different bg color for example Select data (Green), Associated data (White) and

Unrelated data (Gray), I want to show all values like selection field (same as Green, White & Gray) after selection of any deminsion value in Chart object can its possible?

[martin59]

I think you can do that with your expression background color.

you have several systems functions like getfieldselections(), getselectedcount(), getpossiblecount()...

Hope that helps you

[#3]

Thanks, but i have no issue regarding expression color and i used getfieldselections() and getselectedcount()for different purposes but dear when you select any value from dimension its shows only selected value in chart object other values are exculeded form the chart object, i want chart object all values either dimension values are selected or not.

Other than this if you have any example for above question.

[#4]

Thanks, but i have no issue regarding expression color and i used getfieldselections() and getselectedcount()for different purposes but dear when you select any value from chart dimension its shows only selected value in chart object other values are exculeded form the chart object, i want chart object show all values either chart dimension values are selected or not.

Other than this if you have any example for above question, please remember i am talking about chart dimension not field dimension.

[martin59 · Accepted solution]

So you have to use Set Analysis functions :

Per exemple :

sum({1} Amout)

show the total amount for all datas, disreagarding the selections

[#6]

Thanks, Set Analysis I never use before but its fine and i let you know after using set analysis.

[#7]

Boss I did, thanks a lot, its really very good.

[martin59]

Here's a documentation of Set Analysis to better understand this very interesting feature

[#9]

Thanks Martin Favier.