Dimension in set analysis

[#1]

Hello!

I habe a dimension YYYYMM which will be the ascending year and month and i want to count the Field No_ for each dimension where the fields beginYYYYMM <= YYYYMM and endYYYYMM >=YYYYMM

I tried some code samples of the community but i failed

Please help

regards

Georg

[#2]

Count({<YYYYMM={">=$(beginYYYYMM)<=$(endYYYYMM)"}>}Rowno)

[#3]

I´am getting the same Value for each row.

I tried

Count({<YYYYMM={">=$(beginYYYYMM)<=$(endYYYYMM)"}>}[Account No_])

[jagan]

Hi,

I think your expression won't work because the compare is done based on the string not date.  If you have corresponding dates for all the YYYYMM fields then you can do this by using this fields

=Count({<YYYYMMDateField={">=$(=beginYYYYMMDateField)<=$(=endYYYYMMDateField)"}>}[Account No_])

Hope this helps you.

Regards,

Jagan.