COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: foppwin on 28 Oct 2023 06:59:08 PM

Title: Use a subset of attribute data and use that in a calculations.
Post by: foppwin on 28 Oct 2023 06:59:08 PM
I am creating a crosstab where I want the top row to be 2 values from a data item and then a calculation.

Data item D1 contains the values ('A','B','C','D')

I want to create a new data item for value A
I want to create a new data item for value B
and then a calulation A/B

the other side of the crosstab contains 8 different measures.

Title: Re: Use a subset of attribute data and use that in a calculations.
Post by: MFGF on 30 Oct 2023 06:50:23 AM
Quote from: foppwin on 28 Oct 2023 06:59:08 PM
I am creating a crosstab where I want the top row to be 2 values from a data item and then a calculation.

Data item D1 contains the values ('A','B','C','D')

I want to create a new data item for value A
I want to create a new data item for value B
and then a calulation A/B

the other side of the crosstab contains 8 different measures.

Hi,

What are you basing the report on? Are you using a data module or a package? If a package, is it a relational package or a dimensional package?

The answers to the above will help us give you the appropriate solution - it will vary depending on what you are using.

Cheers!

MF.