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




                                                  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!