Help for a newbie!
I am creating an accounting report that needs to have columns showing CURRENT PERIOD values and columns showing YTD values.
Basically it would look like:
Current Period YTD
Amount Budget Amount Budget
Dept 1 $ $ $ $
Dept 2 $ $ $ $
Dept 3 $ $ $ $
TOTAL $ $ $ $
the report is using one Oracle View to get the data. the data is stored by year, by period. in other words the table looks like:
FINANCE DATA
year
period
amount
budget
i have set the report up so that the user enters parameters for Year and for Period.
i built the Current Period columns first and this works great.
now I'm stuck on how to go about adding the YTD columns. it seems like this would require a totally separate query etc.
help!
IP Logged
