COGNOiSe.com - The IBM Cognos Community

                                                Account Count        % Account Count
                                                  Prd1 Prd2 Prd3         Prd2 Prd3
Agency 1   REp1                          5         6     7             6/5    7/5
                 Rep2                           3         3     2              3/3    2/3
                 Rep3                           4         1     0              1/3   0/3
                 Total                          12     10    9              10/12 9/12

Hi guys I have a above dimensional report and this is a new issue happening in % Account Count column against total rows for rep only.

What its doing is taking the count of number of accounts under a  rep for a specific product which had sales  and divides it by number of accounts of that had sales for Shoulder product category for that rep .

The issue is happening only on the row totals below rep which is summarized total for % Account count it always shows 100 %

I am pasting below my expression to calculate % Account column.

Count(([H0 Sales]) within set filter(Children(currentmember([DistributorSalesCube].[ShipTo Customer].[ShipTo Customer])),tuple(currentMember([DistributorSalesCube].[Items].[Items]),[Current FYTD],[H0 Sales])>0))     /   
Count(([H0 Sales]) within set filter(Children(currentmember([DistributorSalesCube].[ShipTo Customer].[ShipTo Customer])),tuple([20 - Shoulder],[Current FYTD],[H0 Sales])>0))


Can you guys help me with this issue .

Thanks,
Nithya

Any help on this is appreciated.

Thanks,
Nithya

                     Account Count                                               % Account Count WRT to Shoulder
                   ALL SHOULDER   Hip Implants & Instruments   Hip Implants & Instruments
Agency1   REP1   2                                0                                          0.00%
           REP2   13                                0                                    0.00%
           REP3   37                               12                                        32.43%
           REP4   33                                 3                                    9.09%
           REP5   18                                  6                                     33.33%
           REP6   24                                 13                                     54.17%
           REP7   26                                 13                                       50.00%
           Total   153                                 47                                       100.00%

Instead of 100% for final % account total the result I am expecting is 47/153 which is 30.71 % . I have no clue why 100 % is shown .

Is my % account count expression screwing up or just the summary total from cognos . If I change the solve order of total to be calculate after %Account count then i get an value of 178% which just sums up the column values .

Thanks,
Nithya