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

Grouping and subtotals in list report

Started by RudiHendrix, 25 Nov 2010 08:39:45 AM

Previous topic - Next topic

RudiHendrix

In Query Studio when I select an item and click "Group" it creates the group and adds an automatic subtotal.

In Report Studio I have a list report and I want to create subtotals per group as well. I can create a group, but I am unable to get in the subtotals. How can this be done?

Thanks!

RudiHendrix

Found it :)

The issue was caused because I was using a joined query.

In that case one has to create the group, insert a footer, add the aggregation, open the lock, insert a singleton in the "in between footer", set the singleton to use the same query as the rest of the report and drag the aggregation into the "in between footer" holding the control key.

MFGF

Sounds very complex!  Normally it's just a case of selecting the appropriate measure in the list and pressing the 'Aggregate' button on the toolbar.

MF.
Meep!

RudiHendrix

It is pretty complex for something that simple.

What you mention works fine as long as one is not using joined queries.

Arsenal

Hmm, I agree with MFGF. It's usually just grouping the report and then clicking the total button to get group sub totals and overall summaries. I think if your list is using the final joined query (say query 1 and 2 join to query 3, query 3 and query 4 join to 5 and you use query 5 as the basis for your list) then you should be able to achieve this.

the method you're using is usually used in slightly more complex cases..such as when you need a sub total row item for a description column in the report but instead of the description being in the footer of the group you want something else, say "sub total"

sakthivelmani

Hi Guys,

I have a list report with multiple columns and there is multiple students for one id. So i grouped all the fields except student field. All the other are grouped , like one id (ABC101), one amount($50) and 10 students.When i do the subtotals, the amount is multiplied 10 times($500). Is there any property that i can change to show the subtotal as $50.

Thanks,
S