2 Replies Latest reply on Mar 11, 2016 2:50 AM by Chandra Shekhar Jain

    Removing Entire Row if one blank (null), or 0

    Sunil Rai

      lets say that I have a data set that looks like this

       

       

                                                 YEAR

                                                  Week (horizontal axis)

      Store 1

      Store 2

      Store 3

      Store 4

      etc etc

       

      I would like to delete any particular store that doesn't have data even for 1 week ( I have almost 13 weeks each year). The weeks have been filtered for the required timeframe from which I would like to exclude any sales data that is null or 0 for the given week.

       

      What forumale do I use?

       

      Thanks for the help!

       

      Cheers,

      Sunil