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