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

Summary Totals for Columns from multiple master detail lists

Started by umariyoob, 10 Dec 2014 01:49:09 PM

Previous topic - Next topic

umariyoob

Hi Guys,

I would like to know if there is a way to summarize a column by getting the totals at the end in a list within one cell of another list that has a master detail relation ship. If this is unclear, I shall elaborate.

Take for instance, a table with Order Lines of a single order. These order lines have multiple items in each line. I have one column in this list that shows order items and their individual quantities that has a master detail relationship with the Order Line. I want to get the totals on this list of every Cell in order_line to show up at the bottom of the list or at the bottom of the entire column. If it is possible, how may I achieve it?

I hope it wasn't too unclear. your advice is highly appreciated!