Skip to Content
0
Former Member
Nov 07, 2005 at 11:28 PM

CKF + RKF + Variable any alternative ?

39 Views

Hello BW Experts,

I have this situation, I have total sales in the row and 24 months in the columns.

Totals has to be calculated as the product of quantity times price. The report should show the rolling 24 months according to the reporting month selected in the variable selection. How can I achieve this.

Possible solutions

1) Make 24 calculated keyfigures ztotsales1-24 (to do the Quantity * Price )and restrict them with a formula variable ZFVAR1-24 , take the user selected month using a customer exit variable ZCVARMON and calculate the 24 values for 24 different formula variables for 24 different months ZFVAR1-24. Wondering if this solution is possible ?

Wondering if there any alternate method using structures. Any suggestions appreciated.

Thanks,

BWer