Hi, need some help.
have month data in database, i need to sum for 12 months
I have this report, where
1. I am Grouping By State.
2. I can get either Month or YTD from my stored procedure.
If I get month then for State AK I get (running Total sum of 8 records) grouped by State.
Now I need a formula which can help me get YTD as 51, means we have
Running Totals 8 for may 2009, thats is for the run date I am using.
And for the whole year we have 51 .
How will I write the formula for this one.
| |
|
|
| |
APPS |
| STATE |
MNTH |
YTD |
|
|
|
| AK |
8 |
51 |
| AL |
26 |
136 |
Edited by vpriyanka2001 - 10 Jun 2009 at 10:57am
IP Logged
