Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want the chart to show no display until some selection is made in some particular fields (field A, Field B, Field C, Field D). Please advise. Also I want to show message in chart, please make selection in field A, Field B, Field C, Field D to show chart/data.
BR,
SAK
Try to use set analysis
avg({<year={"$(=year)"}>}sales)
On the General tab of the charts properties window enter an expression in the Calculation Condition input field. You can use as expression
getselectedcount(FieldA)*getselectedcount(FieldB)*getselectedcount(FieldC)*getselectedcount(FieldD)
Also on the General tab is the button Error Messages. Click on that button, select Calculation Condition Unfulfilled