If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

percentage by nested crosstab help

Started by nsd, 06 Nov 2010 11:11:39 AM

Previous topic - Next topic

nsd

Hi

I need help in calculating the % by product line total. I have attached a sample XML spec. Not sure why i am getting the same result for both my % calculations.

row nesting : product line, product type.
column : 2005
measure : quantity

percentage(quantity tuple 2005 within set product_line)  to get % by grand total
percentage(quantity tuple 2005 within set produce_type) - to get % by product line but
i get the same result as previous calc.

Many thanks in advance.