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

Total Summary for each group in the list report

Started by Rash2021, 24 Mar 2021 05:23:48 PM

Previous topic - Next topic

Rash2021

Hello,

I am trying to summarize each group in a list report, this list is created from a query that is generated from a Native SQL syntax. I tried sectioning then totaling, the totaling only comes at the end of the report. I tried grouping from left to right, still no totaling for each group, just at the end of the report. I tried changing the summary aggregation for each data item (except the ones I want to total which are measures) still did not work, only totals at the end of the page.

I have stages and I want to total the $ amount for each stage under the end of the stage group. Not the total $ amount for the whole list.

Does anyone have any idea how to approach this?

dougp

The summarize tool should have done that if you added the summary after adding the grouping.

Open List Headers and Footers and make sure you have group footers checked for the groups you want totaled.  Then add the totals.  One way to do this is to copy the objects from the table summary into the group summary.  There may be an easier way.