can anybody tell me when do use 'running total'...give an
example for the usage of running total
- 2 Answers
- 8963 Views
- EDS, I also Faced
- E-Mail Answers
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 the difference between drill through, drill across?
how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls
Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance
What do you understand by the term 'aggregate cache'?
What is a scope? can you tell me one example for scope?
What is slicer & dicer ? what is sub session parameter ?
What is the diff between Drill through reports and Master detail reports?
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
--------------Diff b/w ODS and OLAP?
What are initial page components of Cognos connection?
Why need staging area database for dwh?
Can you define transformer?
Teradata 
