Skip to Content
0
Former Member
Nov 20, 2012 at 09:51 AM

creating macro for key figure "period of the preceding year"

28 Views

Hello together,

i have a question regarding the use and options of macros and would be very grateful for your help/feedback.

Let`s take an example for my problem:


As u can see: i have 2 years: 2012 (past) and 2013 (future).

Key Figure 1 (Sales Volume) is generated form former Sales Demand (Data is available from historical data).
Key Figure 2 (Forecast): Planned by Demand Planner (automatically generated)
Key Figure 3 (Period of the preceding year):


- Red arrow: should automatically take the (sales-history-)data from cell: (Key Figure 1 & Month 02 2012)
- Green arrow: should automatically take the (sales-history-)data from cell: (Key Figure 1 & Month 01 2012) AND DIVIDE it into Weeks instead of month.

My question is:
- Is it possible to create a macro which is getting the data from an existing datafield and generate it automatically in the right time-period-unit? (month is always the basis for the past-data)


Tanks in advance,

Holger

Attachments