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
Quote from: nithya1224 on 30 Apr 2015 04:17:16 PM
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.