can anybody tell me when do use 'running total'...give an
example for the usage of running total
Answer Posted / thanjairajan@gmail.com
Returns a running total by row (including the current row) for a set of values
*For example if our list container contain order no,product name,quantity
*Then we drag query calculation
*Then we give name for new column. that name is Total.
*In expression definition window drag running-total function from summaries function of left side available components.
*If we want ruuning-total for quantity,drag quantity data item within running-total function. like running-total(quantity).
*Finally in report output in total column the first quantity value will display in first row of total column, in second row of total column add first quantity and current row quantity, in third row of total column add first,second and current row quantity.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
----------------Diff b/w Dimensional modeling and Relational modeling?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is called Cognos powerplay?
What is Bitmap Index?
What is a Transformer?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
--------------Diff b/w ODS and OLAP?
What is the difference between static and dynamic conditions?
is cognos 7 is better than cognos 8
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is Additive function?
is there any difference between operational database and data base?if yes what r they?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com