3 Replies Latest reply: Apr 13, 2016 5:11 AM by raadwiptec g RSS

    Omit rows in table with no values

    Richard Chilvers

      I have a straight table (Chart Object) which has Dimensions of Sales Product and Day of Year, and an expression of Sum(Sales).

      If a user selects a sales period (eg. March) I would like to only show the rows for products sold on the days for that period. At the moment I am showing EVERY Sales Product, even if every value for the selection is zero.

       

      Any advice?

      Thanks