Identifying a member

[MikeG]

Hi

I have a crosstab with one column as Quarter nested under Year

                                                           Year
                                                        Quarter

I need to add a second column that adds Quarter 1 with Quarter 3

I came up with a solution to identify an individual Quarter using the Item function eg item (members ([Quarter],0 ) gives first Quarter , item (members ([Quarter],2 ) gives third Quarter

But can't see how to add these 2 together

[MFGF]

Hi

I have a crosstab with one column as Quarter nested under Year

                                                           Year
                                                        Quarter

I need to add a second column that adds Quarter 1 with Quarter 3

I came up with a solution to identify an individual Quarter using the Item function eg item (members ([Quarter],0 ) gives first Quarter , item (members ([Quarter],2 ) gives third Quarter

But can't see how to add these 2 together

How about item(members([Quarter]),0 ) + item(members([Quarter]),0 )
or aggregate currentMeasure within set set(item(members([Quarter]),0 ), item(members([Quarter]),2 )))

MF.

[MikeG]

Hi MFGF   

The simple addition didn't work , I just got blank fields however the aggregate method worked a treat

so a big thankyou for all your help