February 19, 2007, 10:36 AM
WilkyCreating a YTD Report
I am trying to figure out how to get a report to be a a running ytd report for each month.
Data:
year: Month: value:
2007 01 05
2007 02 05
2007 03 05
2007 04 05
2007 05 05
2007 06 05
2007 07 05
2007 08 05
2007 09 05
2007 10 05
2007 11 05
2007 12 05
So my Report would be look this
Year: Month: Running Total:
2007 01 05
2007 02 10
2007 03 15
2007 04 20
2007 05 25
2007 06 30
2007 07 35
2007 08 40
2007 09 45
2007 10 50
2007 11 55
2007 12 60
Month 01 = Month 01
Month 02 = Month 01 + Month 02
Month 03 = Month 01 + Month 02 + Month 03
Month 04 = Month 01 + Month 02 + Month 03 + Month 04
Month 05 = Month 01 + Month 02 + Month 03 + Month 04 + Month 05
Month 06 = Month 01 + Month 02 + Month 03 + Month 04 + Month 05 + Month 06
Etc....
February 19, 2007, 10:58 AM
JimRiceTry this:
TABLE FILE YOURFILE
SUM VALUE
COMPUTE C_VALUE/I5SC = VALUE + LAST C_VALUE;
BY YEAR
BY MONTH
ON TABLE COLUMN-TOTAL VALUE
END
Jim
February 28, 2007, 03:06 AM
kalyanswarnaCreate on Temp Variable
DEFINE FILE FILENAME
NEWFIELD/D12 = IF YEAR EQ2007 AND MONTHE LE 10 THEN ACTUALFIELD ELSE 0;
END
Use Actual field as your field and u can use Ampervariables instead of Static Year and Month.
Thanks,
Kalyan