Customer Exit Variable for Text

[#1]

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

[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