2 Replies Latest reply on Jan 30, 2014 1:11 PM by jonathan.richman.2

    Exclude stores with no revenue from year over year growth chart

    jonathan.richman.2

      I have a chart showing store number (row) and year (column). Revenue with the quick calculation year over year growth is shown as text in pane.

       

      The revenue data is for 3 years. Some stores have no revenue in 2011 and some no revenue in 2011 or 2012 because they were not open then.


      I'd like to exclude stores with no revenue (e.g., have no value for a 2012 in the column). I've tried all sorts of filters, but can't seem to figure any out. I don't know how to apply one to say exclude stores with no revenue in a specific year. I'm assuming I can create a calculated field for this, but I haven't been able to get that right either.

       

      I'm afraid I can't share the data here, so hoping someone can point me in the right direction without seeing a workbook.

       

      Thanks,

      JR