Print Page - Identifying a member

Title: Identifying a member
Post by: MikeG on 28 Jan 2015 10:13:59 AM

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

Title: Re: Identifying a member
Post by: MFGF on 28 Jan 2015 10:39:42 AM

Quote from: MikeG on 28 Jan 2015 10:13:59 AM
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.

Title: Re: Identifying a member
Post by: MikeG on 29 Jan 2015 02:55:14 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: MikeG on 28 Jan 2015 10:13:59 AM