4 Replies Latest reply on Nov 10, 2016 6:49 AM by K Chandler

    How to filter stacked bars where a segment of the bar is zero?

    K Chandler

      Hi

       

      I have created a stacked bar chart and only want to keep the rows where a particular segment exists. I have used the Superstore data to try to explain what I mean (see attached). In this example I am showing the sum of sales by customer and segmenting the bars by category. I want to filter out customers that didn't buy furniture but, for the customers that did, still see the full breakdown of sales by all categories.

       

      I feel sure I must be missing something obvious! Any help would be much appreciated.

       

      K