Skip to Content
0
Former Member
Jun 06, 2007 at 11:26 AM

Urgent : extra column needed in report

8 Views

Hi All

I have a query which displays the data for twelve months for a fiscal year.

Rows:

KF1

KF2

KF3

Column:

Posting Period

So the display of report is similar to

Period , 1 , 2 , 3 , YTD, BOY

KF1 , 0.000 , 0.000 , 0.000 , ,

KF2 , 0.000 , 0.000 , 0.000 , ,

KF3 , 0.0 , 0.0 , 0.0 , ,

The no of periods is being enetered via a selection screen variables.

Now I want to add two more columns i.e YTD and BOW (already shown)

YTD would show the sum of the data till the current period

BOY will show the sum of the data for the balance of Year.

I do have variable to restrict the data as per the logic but I am not able to find a solution to add these two coluns.

I have tried adding new slections in the columns area but it does not help and merges with the periods. I want these two coluns separately in my report.

Please help. Its urgent

Message was edited by:

Shantanu Mukherjee

Message was edited by:

Shantanu Mukherjee