Hi,
My table is like
A/C_NO----BUD_00------YTD_00------BUD_01-----YTD_01-----BUD_02-----YTD_02
014-----------1000------------10---------------1000---------20------------1100-----------30
the result I want is something like:
A/C_NO----BUD_01------EXP_01
014-----------1000------------10
BUD shows the budget
EXP_01, is the EXPENSE in period 01,
which is calculate as the period specific expense and calculated as
(YTD_01) - (YTD_00).
User selects, which period, he wants the information for, like 00,01,02
How do I do this….I am clueless…. :-o
-dipali