Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.
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])
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)