Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mixels on 12 Jul 2014 07:28:15 AM

Title: Percent of a total in crosstab for 3 different data items not calculating
Post by: mixels on 12 Jul 2014 07:28:15 AM
Hi -

I am trying to calculate % of a total by year, by region, by salesrep of a total for the particular year. My report looks like the example below but I am not getting correct % of total calculated.

Year   Region   Salesrep   Sales   % of total
2012   Americas   Peter   1000   13%
2012   Europe   Jack   2500   33%
2012   Asia   Cornel   4000   53%
Total 2012      7500   100%
2013   Americas   Peter   3400   33%
2013   Europe   Jack   4500   44%
2013   Asia   Cornel   2300   23%
Total 2013      10200   100%


I tried using percent([Sales] for [year]) but didn't work. I also tried using percent([Sales] at [Salesrep], for [year]) and still didn't get the right percent. Not sure how to get the % caclulated correctly.

Any help would be appreciated.

Thank you!
Title: Re: Percent of a total in crosstab for 3 different data items not calculating
Post by: mixels on 12 Jul 2014 07:39:07 PM
Solved my own issue. Thanks!  :)
Text only | Text with Images