Pivot Table - Remove null transaction in last 3 months

[DennySetiawanJAPFA]

Dear Expert,

I want to display all of Customers who ALWAYS have transaction in last 3 months. If there is a customer in the past 3 months have null value (no transaction) for at least 1 month, I want to remove it from my display report.

This is my current display:

Then I want to remove Customers: AA FISHING and AAN PRASETYO from my display report, because they have at least 1 month null value (no transaction) in the past 3 months.

So, my expectation result should be like this:

I've already uncheck the 'Include null values' in my dimension, and uncheck 'Include zero values' in Data handling. But the result still not my expectation. Do you have any solution about this? Thank you.

[DennySetiawanJAPFA]

Hello, I'm still looking for a solution regarding this case. Maybe someone can help.

Thank you.

[Digvijay_Singh]

May be something like this in the calculated dimension, expression may not be perfect as not tested - 

Aggr(Only({<Customer Desc={"=$(=len(Aggr(Sum({<MonthYear={">=$(=Max(MonthYear,-3))"}>}MetricValue),MonthYear))>0)"}>}Customer Desc),Customer Desc)

Tried to check if any of the last three months metric value is not null then only show Customer desc.

Thanks,

DJ