How to keep 12 periods with 2 restricted key figures?

25 Views

Hi There!

Hope someone in this forum could help us.

We have two restricted key figure on specific time period and version (actuals & planned data), let say key figure KF1 restricted from Period 1 to 3 and key figure KF2 restricted from Period 4 to 12.

We would like to get following report

	[KEY FIGURE]	KF1			|KF2
	[PERIOD]	1	2	3	|4	5	6	7	8	9	10	11	12

[0MATERIAL]		
A001			30	30	30	 30	50	...
A002			25	0	40	 40	...
...			20	56	45	 20	...

Unfortunately, query designer is always combining all periods with all key figures: ie we've got additional periods 4, 5, 6, 7, 8, 9, 10, 11, 12 for KF1 and 1, 2, 3 for KF2 - total 24 periods.

We tried to remove 0, unfortunately we've got unwanted behaviour: on some material some periods are empty like A002 for period 2, if we restrict on A002, period 2 disappeared.

We would like to get always 12 periods.

Could you help us? Do you have any idea? or suggestion? many thank for your help.

Kind Regards

Olivier