Interview Questions   Tutorials   Discussions   Programs   

Cognos - Can anybody tell me when do use 'running total'...give an example for the usage of running total?




1156
views
asked mar October 5, 2014 03:32 AM  

Can anybody tell me when do use 'running total'...give an example for the usage of running total?


           

1 Answers



 
answered By vishnoiprem   0  

If you want see the day wise total that situation use running total function.

SEL NAME, MEASURE, DATE,
SUM(MEASURE) OVER(PARTITION BY NAME ORDER BY DATE ASC ROWS UNBOUNDED PRECEDING) AS CUM_AMT
FROM <<TABLE_NAME>>
ORDER BY NAME, DATE ASC;
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

cognos × 1

Asked 2 years and 3 months ago ago
Number of Views -1156
Number of Answers -1
Last updated
3 years and 2 months ago ago

  Similar questions


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert