How to use cyclic group

[Anonymous]

Hi community,

How to use cyclic group in expression?

I have dimension

Time group (MYear, QYYYY)

and expression

Count({<[qID_3_Task completion]={'Yes'}>} [qID_3_Task completion])/

Count(TOTAL <[MYear,QYYYY]> [qID_3_Task completion])

What should I use instead of MYear, QYYYY?

Thanks,

[Nicole-Smith · Accepted solution]

Try:

Count({<[qID_3_Task completion]={'Yes'}>} [qID_3_Task completion])/

Count(TOTAL <$(=GetCurrentField([GroupName]))> [qID_3_Task completion])

Replace GroupName with the name of your cyclic group.