I have a dataset which contains 5 columns. First column is a dimension which will be used as filter and other columns are facts.
I have two clusters in a filter, for cluster 1 there are column A,B,C. for cluster 2 there are column B,C,D. When I build waterfall chart, it shows all the columns on x-axis A,B,C,D.
When, i put a filter for cluster 2 then chart shows the values for columns A,B,C,D but also show the 0 value for column A.
How to remove this 0 column from the chart.