cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Key Figures

mv1985
Participant
0 Kudos

Hello,

We have a requirement as below :

User want to see growth in percentage based on selection of ex : 0CALMONTH, 0CALYEAR for a particular Keyfigure like Net Value .

If user select 0CALMONTH for NETVALUE and loads 4 months say March, April, May, June then 4 OTHER fields should display growth between the selected months as March-April growth, April-May growth and so on . The new fields should be displayed dynamically based on selection of time characteristics and the number of months that are loaded and accordingly populate as mentioned above.

Because user will be dynamically selected Months/Years so these new fields should also appear and populate dynamically based on selection.

Please suggest how it can be implemented .

Regards,

An

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

I think you can create fix structure like below.

Create 12 selections for displaing Jan - Dec data.

In first selection , drag your Key figure Netvalue and calmonth. Create  a customer exit variable on calmonth , say V2.

Use the calmonth from query input say V1 and calculate v2 from customer exit. Basically V2 will hold 1st month in the year that is Jan.

Now for each selection from Feb - Dec , offset the calmonth by +1, +2,+3 ..+11 to get Jan to Dec Netvalue

Now again create 12 formulaes like Feb-Jan , Mar - Feb,....Dec - Nov

use the selection from part 1 and subtract in formulae to get the difference.

Now when report is executed you can suppress the rows/columns that are irrelevant. So if user selects 04.2015 only 4 columns will be displayed after suppression.

Not sure if there is a better approach

Thanks

Answers (0)