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

How to print Total after every 10 Rows

Started by S_N_Solution, 03 Aug 2009 01:33:50 AM

Previous topic - Next topic

S_N_Solution

Hi All,

I have req to design a report in which i have to print the TOTAL of measure after every 10 Depts or every 10 rows.For eg:

Row No   Dept No  Sales
   
1   101   11
2   102   22
3   103   33
4   104   44
5   105   55
6   106   66
7   107   77
8   108   88
9   109   99
10   110   100
Total      110
11      
12      
…..      
……      
      
20      
Total      

karun218

Hi ,

Please follow the below procedure

1) create Data item called running count and write the following expression inside that

  "ceil((running-count([Deptno])/10))"

2) you will get the output as below

rownum  Deptno   Sales   running-count
-------- ------- ------  ---------------
1           101        10           1
2           102        20           1
3           103        30            1
4           105        10            1
5
6
7
8
9
10
11         107       10              2

3) Now you can group on running-count column and then select measure column in our example "Sales" apply total for that

Now you will get the total based on running-count  column

please try this one...

Regards,
Karun

S_N_Solution

Thanks a lot Karun....It's working  :D