Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I taken inline load, with field Filter and values are sellin, sellout,Quantity. I taken a (Grouped)bar chart with 3 measures sum(sellin),Sum(Sellout),sum(Quantity) and Date as dimension
i taken that filter with 3 values as button. when no selection, all 3 bars to be appear in chart. when any one selected only that bar to be appear, if any two selected those two bar to be appear on the bar chart.
I write calculation condition as if(GetselectedCount(Filter)=0, or Getfieldselections(Filter)='Sellin',1,0) works fine for single selection and no selction in filter buttons.
Please tell me how to write calculation condition when sellin and sellout button are slected from filter. that time user want to see two bars (sellin and Sellout Bars) on chart
Try this
=GetSelectedCount(Filter)=0 OR wildmatch(GetCurrentSelections( Filter, '|'),'*Sellin*')