Skip to Content
0
Former Member
Sep 11, 2007 at 06:00 PM

How to add three columns under a column of Column Structure in BEx Query ??

28 Views

Hi all,

I have created a Structure for Taxes (with 10 rows) under Rows and another Structure for Company under Columns and it has 3 columns like Company A, B & C. Now I want to have three columns (Actual, Forecast & Total) under each company A, B & C. It means it will have 9 columns under these 3 companies.

The ACTUAL should calculated as:

Version = 100 and

Months = Plan Begin Month - 1.

If the Plan Begin Month is 4 (April) then ACTUAL should be calculated for first 3 (4 - 1) months only.

The FORECAST should calculated as:

Version = 699 and

Months = From 4 (April) to 12 (December).

'Plan Begin Month' will be entered on the selection screen.

How can I design this query, PLEASE ?

Thanks in advance.

Regards,

Venkat.