Use dimension field value in formula's set analysis in chart

[ziabobaz]

hi!

I have the following task - count only those clients, who were active in current month AND made their first order in the same month.  In particular, i need to build a formula where current month is compared with the 1st purchase month. 

This is simplified example, as i have a lot of clients and periods in my original datamodel.

I know set analysis is calculated once per chart disregarding dimension value per row, but maybe there is a workaround?

Thank you!

count( {< Client = p(<Month = 1stPurchase >) >} Client ) 

[sidhiq91]

@ziabobaz  Could you please provide some data sample on this ? Let me see if I can help you in anyways. Thanks.