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
What is Additive function?
What are the themes in a data warehouse?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Can you define cube?
What do you understand by ‘ibm predictive maintenance and quality’?
What are the components of the report studio?
What is the difference between Open Connection command ang Open Session Command?
What are the different uses of a repository manager?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
Explain about scorecarding?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
how to create cubes in transformer ?
What is defined as data mining?
What is the importance of having monitor service in cognos?
What do you understand by the term 'dynamic cube'?