Accumulated
May 13, 2008
hello,
i want do a acucumulated of count of rows by rowgroup 1 ,2 and 3 and by year , quarter and month.
how can i do accumulated into cells?
- year
-quarter
january
january
febreary
febreary
- rowgroup1
count
Accumulated
count
Accumulated
- rowgroup2
aggregate(counts rows )
aggregate(counts rows )
- rowgroup3
- rowgroup2
- rowgroup2
1
1
3
4
View 1 Replies
Feb 27, 2008
I've created SQL statement to display data that include Project ID, WBS Element, DebitTotal, CreditTotal, Net (net figure is sum between DebitTotal and CreditTotal = CreditTotal - DebitTotal), FiscalPeriod and FiscalYear. To display data I need to key-in the timekey. If 200702 refer to data for February 2007.
The problem is, how to calculate accumulated figure for Net? I have to display YearToDate figure which is accumulated figure for every month for Net table.
e.g Net for February is 1000, March is 2000. YearToDate should be 3000 (1000+2000).
Another problem is because I'm using the timekey to display the data, table name is the same for every month.
How to accumulate the Net figure? Please help.
View 3 Replies
View Related
