COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: user_src on 18 Jun 2015 04:54:58 AM

Title: Crosstab with percentage after each product line
Post by: user_src on 18 Jun 2015 04:54:58 AM
Hi All,

Need some help urgently.

I have a requirement in a crosstab (screenshot attached)

                                    January
                               Qty        Unit Cost
Golf Equipment        10            2
                          %   0.3         0.1

The % calculation for product line to be done for Qty and Unit Cost. Please suggest

The rest of the design has been achieved.

Title: Re: Crosstab with percentage after each product line
Post by: user_src on 19 Jun 2015 04:24:36 AM
Please help
Title: Re: Crosstab with percentage after each product line
Post by: MFGF on 19 Jun 2015 04:44:46 AM
Quote from: user_src on 19 Jun 2015 04:24:36 AM
Please help

Hi,

I'd guess nobody has ventured an answer because you haven't given enough detail to allow them to? All we know is that you want some sort of % values. We don't know what the % calculation should be based on though - you haven't given anybody that information. % of what? In what context? We don't know if you are using a relational or a dimensional package. Perhaps if you make a little more effort to explain what you need (rather than just posting "please help") you might get more success?

Just a thought.

MF.
Title: Re: Crosstab with percentage after each product line
Post by: Lynn on 19 Jun 2015 04:56:19 AM
The forum etiquette post gives examples of what type of information is useful to get a good response.

http://www.cognoise.com/index.php/topic,24030.0.html