Customer Exit Variable for Text

[former_member374954]

Hello Guys,

I have a requirement where user wants to have a Interval Selection on Fiscal Period. The user would enter a range and data should be displayed in different columns for that range of period. So for eaxmple If user selects 001/2015 - 003/2015, It should show three columns for each key figures. FOr this I used a standard Fiscal Period Variable and added that to Columns on top of Key figures see screen shot below:-

But it gave me results like below. User requirement is he wants to see all keyfigure of one period together.

How can I do that?

Any Idea how can I achieve that?

Thank you

Regards

Prashant

[former_member185132 · Accepted solution]

Your result screenshot shows that you are already seeing all KFs of one period together. The Actual Sales Volume and YTD Budget for 004.2015 appear together, followed by those two KFs for 005.2015 and so on. How is this different from what you want to achieve?

An example of the required output would help.

[former_member374954 · Accepted solution]

My bad.

I want to see one keyfigure for all months together.

regards

Prashant

[Former Member · Accepted solution]

Then simply move the Fiscal Year Period below the Keyfigures it will solve the problem.

[former_member374954 · Accepted solution]

You are awesome!

[Loed]

Hi,

If you will be doing this in a workbook, then you can create two (2) queries: 1 for your per period and 1 for your YTD..

OR

You can just use the SUM formula of EXCEL for your requirement..Just use an IF statement so that columns will not have a gap..

Regards,

Loed