4 Replies Latest reply on Jan 20, 2016 2:43 PM by Shawn Wallwork

    Exclude uncomparable data (by month) at aggregated level

    Sunil Rai

      Is it possible to exclude data for stores that have not comparable month level data from a total aggregated data set?

       

      In the attached file, I wish to create a bar chart, showing growth of all stores in my company, only for stores that have full data sets for both years. If Store 3 doesnt have September data for 2012, I want to exclude Store 3 entirely from my total aggregation of sales across the two years.

       

      Basically the intention of this exercise is for me to compare stores that have FULL comparable data.

       

      Thanks!