If vs Set Analysis Using Dimensions

[timothyj]

Pretty sure this is not possible, but wanted to double check.

My chart expression is:

=Sum(If([END DATE]>[MONTH YEAR] And [START DATE]<=[MONTH YEAR],[MEMBERSHIP FEE],0))

Making a chart where [MONTH YEAR] is the dimension to track memberships over time. This works. I cannot do this in Set Analysis, can I? 

A similar count expression that will work:

=Count(If([END DATE]>[MONTH YEAR] And [START DATE]<=[MONTH YEAR], [MEMBERSHIP NUM]))

Again, there is not a Set Analysis expression that will work.

Googling the forum suggests this is because Set Analysis only calculates once per chart?

Thanks! 

[timothyj]

Teamwork! Thank you Taoufiq & Kush! I ran it through the big data set adding the RowNo() Key and had success! 

Thank you both for helping folks out!