Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pricter on 17 Feb 2010 08:07:37 AM

Title: Percent of Product Sales on Produt Line using cube as a datasource.
Post by: pricter on 17 Feb 2010 08:07:37 AM
Hi all,

I would like to compute the percetage of product sales against the product lines sales based on a cube package.
For Example if we have the Product Line A with sales 100 and the Products A (20 Sales), B ( 30 Sales), C (50 Sales)
and the Product Line B with sales 50 and the Products D (25 Sales) and E (25 Sales)
I would like to produce the following crosstab:

              Line Share
A                   20 %
B                   30 %
C                   50 %
D                   25%
E                   25%

Could someone help me how could I achieve that.
Title: Re: Percent of Product Sales on Produt Line using cube as a datasource.
Post by: paddhu on 19 Feb 2010 06:16:51 AM
Use the Member summary function percentage([dataitem] within [set]).
Text only | Text with Images