Display based on number of rows

[#1]

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.

[sunny_talwar]

Is this what you are looking for? PFA

Country will be a calculated Dimension as follows :  =If(Aggr(Count(Date), Country, Store, YearMonth) > 3, Country)

Best,

S

[#3]

Thank you so much for your reply. I should say that I put a bad example there

The file should actually be like following and attached.

And the final report should be

I tried your method to put calculated dimension for YearMonth as YearMonth=If(Aggr(Count(Date), Country, Store,YearMonth) > 3, YearMonth) but failed.

Please help.

[sunny_talwar · Accepted solution]

Does this work?

YearMonth Dimesion would be: =If(Aggr(Count(Date), YearMonth)> 3, YearMonth)

Best,

S

[#5]

Thank you so much. It works perfectly. I also forgot to check the 'Suppress when value is null'.

[sunny_talwar]

No problem.

Best,

S