Using Cyclic Dimension in chart expression

[prees959]

Hi,

I currently have this expression in a 100% stacked bar chart :

=sum([Count])/sum(TOTAL <Date>   [Total ])

I would like to have a Cyclic Date group as a dimension.  is it possible to use a cyclic group in the expression in place of the Date dimension??

Many thanks.

Phil

[swuehl]

You can either use a dollar sign expansion with GetCurrentField() to get the active field of your dimension group, or just use all fields of the group in the TOTAL field list, like

=sum([Count])/sum(TOTAL <Date, Month, Year>   [Total ])

or something like

=sum([Count])/sum(TOTAL <[$(=GetCurrentField(DateGroup))]>   [Total ])