Comparing two fields on Set Analisys

[Anonymous]

Thats my data cloud:

TABLE: ATTENDANCE_REGISTER

COLUNS: "REG_NUMBER", "YEAR_MONTH_REGISTERED", "YEAR_MONTH_CLOSED", "%KEY_YEAR_MONTH_NUMBER"

TABLE: CLIENT

COLUNS: "CLI_NUMBER", "YEAR", "MONTH", "%KEY_YEAR_MONTH_NUMBER"

I wanna make a pivot table with these dimensions: "YEAR", "MONTH" and this expression: the quantity of ATTENDENCE_REGISTER that was registered and closed at the same year_month.

The Set Analisys i'm using is:

COUNT({<YEAR_MONTH_REGISTERED={'$(=YEAR_MONTH_CLOSED)'}>} REG_NUMBER)

But it doesnt work! Any one help me?

Thanks!

[m_woolf]

Try:

COUNT({<YEAR_MONTH_REGISTERED={YEAR_MONTH_CLOSED}>} REG_NUMBER)

[Anil_Babu_Samineni]

Sorry to say, syntax is wrong. Should be this

If(YEAR_MONTH_REGISTERED=YEAR_MONTH_CLOSED, 1,0) as flag

And expression is

Count({<flag = {1}>} REG_NUMBER)

Or

COUNT({<YEAR_MONTH_REGISTERED={"=YEAR_MONTH_REGISTERED

=YEAR_MONTH_CLOSED>} REG_NUMBER)

Or finally

Count(if(YEAR_MONTH_REGISTER= YEAR_MONTH_CLOSED, REG_NUMBER))