Combine members in to a single member

[cognos05]

Hi,
In dimensional reporting I have few members in Months level as jun,july,august,sep etc...
I wanted to combine 3 members together and give it a name.

If say sales of Product b was 100 , in jan ,feb and march

I would show product b in row and only in one member in column which  will show the 3months combination.

Thanks,
Nithya

[MFGF]

Hi,
In dimensional reporting I have few members in Months level as jun,july,august,sep etc...
I wanted to combine 3 members together and give it a name.

If say sales of Product b was 100 , in jan ,feb and march

I would show product b in row and only in one member in column which  will show the 3months combination.

Thanks,
Nithya

How about a calculation that first aggregates the month measure values eg

aggregate(currentMeasure within set set ([jan member],]feb member],[march member]))

You could then use a member() function around this to convert the value to a manually defined member of the Time hierarchy:

member(aggregate(currentMeasure within set set ([jan member],]feb member],[march member])),'QTR-1','Quarter 1', <your time hierarchy>)

MF.