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

Crosstab percent aggregation-Please help

Started by Kcog123, 04 Mar 2014 03:13:20 PM

Previous topic - Next topic

Kcog123

Hi all,
I have a crosstab with two measures count and percent for each date in a week. and two summaries one total total(week) and one percent of that total.

Month(Jan to Dec) as data item
      Week1            Week2       Total(Week) Summary   
         Date1      Date2      Date3         
         Count   Percent   Count   Percent   Count   Percent         
Status A      477     75%   176   26%   727   81%     1380        62%
Status B      152     24%   41   6%   160   18%     353        16%
Status C      10      2%   464   68%   9   1%     483        22%
Total Status  639     100%   681   100%   896   100%     2216        100%

I could able to get the percent at date level as ,
percentage([count] for [Date])

and summary percent as total([count] for [status])/total([count] for Month).
changed summary format to percent. and aggregation as calculated.

I am getting the summary level percent by status A,B,C WHICH ARE 62%,16%,22% but the grand percentage at the end i.e.100% i am getting like either 33% or 22%...etc.

Why is it? and how can i get the 100% like the other percatage totals.
Can anyone please reply. This is a very urgent request.

Thanks in advance.