Chart show default values, but change by selection

[kfir1987]

Hi,

I am trying to create a chart with default presentation, but on selection the chart will change to view as pair as the selection.

My dimension is Time (Year-Quarter) and Material and the measure is sum of  usage. In general, the chart should show usage per material over the time.

So I want to show by default the materials: X,Y and Z. But when the user select the material A all the default selection will disappear and only matiral A will be show.

Of course when the user clear his selection, the chart will show again the default selection .

Thank you

[sibin_jacob]

Can you explain little more.

How you are showing the materials: X,Y and Z by default?

Can you please share your expression and dimension?

if you want to exclude the material selection, you need to use material = in the set analysis.

[kfir1987]

Hi

regarding your question "How you are showing the materials: X,Y and Z by default?" - This is my question

my expression for Sum([Usage])

[sibin_jacob · Accepted solution]

Okay,

Please use the below formula for materials Dimension, and check " suppress when value is NULL"

=if(GetSelectedCount(materials)=0,

if(match(materials,'X','Y','Z'),materials),

materials)