3 Replies Latest reply on Nov 28, 2012 11:22 PM by Nathan Schofield

    Top X for a Stacked Bar not working

    Nathan Schofield

      Hi All,

       

      I have a stacked bar graph for which I want to create a nested filter to keep the top x apps per publisher.

       

      Screen Shot 2012-11-28 at 11.15.58 AM.png

      I have read of solutions that use Index and then a filter, but can't seem to implement them when I have a pill on the color shelf.

       

      I have two problems:

      1) I can't seem to get index to work with my pill on the color shelf.

      2) When trying to resolve myself I think that there is a problem of an app not being available in every country (this may not be a problem with a good solution), but essentially there are nulls in the dataset.

       

      I have attached a workbook with dummy data. Look forward to suggestions.

       

      Regards,

       

      Nathan Schofield