cyclic group within same field??

[#1]

Hello,

I have a table that has two fields. Periods and consumptions. Periods has two kind of periods. one period and four periods...and these two types have different consumption. now I want a chart that has cyclic group within this periods field (User being able to select whether one period or four period.). I know that when you have two fields, you just create new group and drop those two fields there. but is there any way to make a cyclic group within the same field values

Arif

[#2]

You can add calculated dimensions to a cyclical group. Just click the 'Add Expression' button under the 'Used Fields' box in the Group Settings box.

dimension 1: if(period = 1, 1, null())

dimension 2: if(period = 2, 1, null())

Then in your dimension settings check the 'Suppress if value is null' box to limit it to show only those values for the appropriate period.