on 12-30-2014 6:35 AM
Hi Experts,
I have a FI-GL custom query that displays all months of the year as Key Figs. The filter is on Year, Version. Want to add FTM (For-The-Mth) and YTD columns. If I select period as 002 in the variant the below result is to be displayed. see fig:
Jan | Feb | Mar | FTM | YTD |
---|---|---|---|---|
150 | 100 | 400 | 100 | 250 |
200 | 25 | 250 | 25 | 225 |
230 | 50 | 300 | 50 | 280 |
We are getting the monthly figures and the year as part of the Version (A2012 or A2013 etc.) from the custom datasource. Fiscyear or FiscPER are not being used.
Thanks
mf
Hi Farot,
Can you take a screenshot of rowsxcollumns of your Query definition under Query Designer?
This could enlight someone to figure out what is going on..
Regards,
Edward John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.