CKF + RKF + Variable any alternative ?

[#1]

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

[Former Member]

Hi BWer,

You can use just one user entry variable for reporting month.

Create a structure in columns with 24 selections. In each selection will be 0CALMONTH, restricted by a var with different offsets (0 : -23) for different selections.

Into a structure in rows put Quantity (hidden row) and Price (hidden row). Add there a formula for calculating amounts.

That's should be it!

Best regards,

Eugene

[Former Member]

Greate Eugene, Thanks for your reply.

I have did according to what you have said, with one little change. In the column I restricted the calmonth with the reporting variable. with a value range(first -1 and then -24). So I need not create all the 24 columns and selections.

But my situation is more interesting. The Price itself is a CKF and quantity is a RKF. Is it still okay if I can keep the CKF and RKF in the structure and then use them in the formula in the structure ?

Any suggestions appreciated.

Regards,

BWer

[Former Member]

Yes, it's OK. Formula in the structure may be based on both CKF and RKF.

Best regards,

Eugene