5 Replies Latest reply: Jan 29, 2015 3:12 PM by Sunny Talwar RSS

    Display based on number of rows

      I currently work on the calculation of the sales as following and attached:

      I like the report to only show the sales if the number of transactions is more than 3 times. For example, HongKong only has sales of 3 times so that it shouldn't appear in the report. The ideal report should like following:

       

       

      I assume that count() function should be used to get the number of rows. If number of rows is less than 3, don't display. Tried couple of times and still couldn't figure out.

       

      Please help and thank you in advance.