Question Re: Customer Exit Variable for Text in Technology Q&A

Customer Exit Variable for Text

Former Member — Wed, 05 Aug 2015 19:51:52 GMT

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

Re: Customer Exit Variable for Text

Former Member — Thu, 06 Aug 2015 03:49:43 GMT

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.

Re: Customer Exit Variable for Text

Loed — Thu, 06 Aug 2015 09:21:02 GMT

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..

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

Re: Customer Exit Variable for Text

Former Member — Thu, 06 Aug 2015 13:31:56 GMT

My bad.

I want to see one keyfigure for all months together.

regards

Prashant

Re: Customer Exit Variable for Text

Former Member — Thu, 06 Aug 2015 13:55:29 GMT

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

Re: Customer Exit Variable for Text

Former Member — Thu, 06 Aug 2015 15:07:10 GMT

You are awesome!