Hide chart when blank value captured

[Anonymous]

I have set of data where I need to hide the chart when ever the data has null values .

In the given sample application no data is present for 2017 and in 2018 north region data ,so the  chart should not be visible whenever

the null values are present in the chart

[tresB · Accepted solution]

Layout->Show Conditional expression:       Rangesum(Sum(Amt),Sum(SALES), sum(Order))

[Anonymous]

Is it possible to implement the same ,if  we are using calculated dimension using valuelist function  in dimension and expression and using sum function instead of count

[Anonymous]

Thanku very much treseco for your reply.very well appreciated