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

List subtotals With new data item

Started by barrysaab, 06 Mar 2012 09:58:49 AM

Previous topic - Next topic

barrysaab

I had created this report a while ago which i forgot how i did it ,it is a list report and in the subtotal section i need to insert new data item which is a grouped data item,i tried creating new header and all other options but couldn't able to get what i want.Please Help.Thanks
Boy! Cognos getting on to me!!!

barrysaab

Boy! Cognos getting on to me!!!

barrysaab

Boy! Cognos getting on to me!!!

pricter


barrysaab

Sorry for misunderstanding ,what i meant to say i created by following your given steps,which i completely forgot now.Thanks again and appreciate help.
Boy! Cognos getting on to me!!!

barrysaab

Pricter,iam trying to get the layout as the report has been done,could you be kind enough to post the steps again,Particularly the grouped data Item.Thanks
Boy! Cognos getting on to me!!!

pricter

1.Create a list with the
Data Item 1
Product Line
Quantity
2.Group List on Data Item 1
3. Summarize Quantity
4. Split the cell of "Summary"
5.Place the "Data Item" in the subfooter of the Product Line
6.Cut the total summary row and the Data Item 1 column
7.Apply the style format to the Product Line subfooter.

I hope the steps are clear

barrysaab

Thanks a lot,Pricter.I will give it a go.
Boy! Cognos getting on to me!!!

barrysaab

Thanks,Pricter.I have got it.Appreciate your help.
Boy! Cognos getting on to me!!!