Skip to Content
0
Former Member
Nov 29, 2006 at 07:31 AM

Help with a query regarding time dependent display of Plan/Actual data

36 Views

Hello,

Let me try to explain what my problem is:

I have a query that shows plan and actual sales figures on a timeline. Plan and actual data is identified by 0VERSION (P01 for Plan; P00 for Actual).

0CALMONTH and Sales key figure is in rows. 0VERSION is in collums.

The output looks as follows (simplified):

CalYYYY/MM............P01....P00

2006.09......Sales........90.....100

2006.10......Sales......100.......95

2006.11......Sales........90........0

2006.12......Sales........95........0

So far so good! But users aren't satisfied with that. They want only <u>one</u> collumn with sales figures. For past months (< 2006.11) they want to see actual figures (Version P00). For current and future month (>= 2006.11) they want to see plan figures (Version P01). And this only in one single collumn.

So the output should look this way:

CalYYYY/MM..........P00/P01

2006.09......Sales......100

2006.10......Sales.... ...95

2006.11......Sales........90

2006.12......Sales........95

Is there any way/workaround to accomplish this?

Your help will be very appreciated!

Regards,

Ulrich