Variables and structures for current/YTD

[Former Member]

Hi there,

I have a report (not working yet) with 1 key figure structure and 1 char structure in the columns. Key figure structure define PA data like revenue, gross margin, gross margin % etc.

Then I have created a char structure to define:

1) Selected period (if user enters in the variable screen e.g. 4-6 for periods, this shows then data only for period 6 here)

- Actuals

- Budget

- Variance

- Previous year actual (same period)

- Variance (current year vs. previous year actuals)

2) YTD (should not actually show year to date, but if entered periods 4-6, it should display those then)

- Actuals

- Budget

- Variance

- Previous year actual (same period)

- Variance (current year vs. previous year actuals)

Revenue

Selected period | Actuals | Budget | Variance | Prev year | Variance | YTD | Actuals | Budget | etc..

Could someone advice me on how to get this scenario working, I am not sure whether I should use Fiscal year/period...Fiscal year..posting period... what kind of restrictions (filter) and variables. I have the layout ready but the calculation definitions separately for Selected period / YTD is not working. Does someone have good ideas?

Thanks in advance!

[P095090]

HI,

U can create 2 customer variable to get the data according to your req with defining lower and upper ranges accordingly

[Former Member]

Hi

If I got your question properly...

Create 1 variable with between values as user entry mandatory . Based on this create RKF with the user entry values with the related Key figures and time keys.

For 4-6 months you may have to go for Conditions , Not sure.

Hope it helps