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

Sectioned Report totals

Started by barrysaab, 17 Sep 2011 11:39:41 AM

Previous topic - Next topic

barrysaab

In my report i have columns Region.organization,and category desc.The user wants to see the sale information of each category separately organization wise,such as he want to see western regions and organizations id's belongs to that region.I have grouped all three columns and sectioned on category desc.i have got each region and organization's associated with it and subtotals such western region xxxxx.Now the end user wants to see all region's summary totals with each category.for ex

Videos
----------
western region| jksx
                        | kkk
                  -----------
subtotals---------------
southern region|jkm
                         lkil
                         pmp
subtotals------------------
he want summary of these subtotals in each section.I have tried adding list footers and other things but nothing seems to be working.Please Help.Thanks
Boy! Cognos getting on to me!!!

annival

Did you ever get around this issue? I have the same problem. I have a crosstab report with users and their reported workhours. I created a section based on the User so the end user can view the report based on user. They also want to know the total working hours for each selected users and I can't find a solution, how to show the total of the subtotals in each section.

bi4u2

I am hoping to revive this post. I have a report studio report that I have sectioned (as opposed to grouping). If I add a total, it just gives the grand total of all sections. Is there a way to add a section total?

blom0344

Why not override the definition of the subtotal by an aggregate within the context?

total([measure] for [sectioned_dataitem])