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.