can anybody tell me when do use 'running total'...give an
example for the usage of running total
Answers were Sorted based on User's Feedback
Answer / 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 |
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?
what is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,
difference between imprompt and reportnwt1.1
How do we create Links & Segments in Cognos Framework Manager?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
what is meant by roll up and roll back in dataware housing????
4 Answers Covansys, IBM, Wipro,
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
Explain difference between powerplay transformer and power play reports?
can any one pls send me the project flow at the time of interview
How do you test the reports? Explain the Unit testing procedures after developing the reports?
What is the metric store database?