Count and Rank table chart by 2 expressions: current and YTD

[mazacini]

I have a straight Table chart with expressions for Current Month Sales (as selected) and YTD Sales (using SET Analysis).

Dimension is Customer.

I want to introduce columns based on Rank and Count.

Some YTD Customers will have no activity in Cuurent Month.

How can I exclude these from the Rank and Count calculations for Current Month?

[goldnejea8]

How about something like this?

sum( {$<Customer = {“=Sum({1<Month=>} Sales ) > 0”}>} Sales )