Skip to Content
Former Member
Oct 25, 2012 at 01:37 PM

To find average of one key figure for one fiscal year


I want to see the values of different key figures for different fiscal year periods.

For this reason , I have 0fiscper on top of other key figures in my column in query designer.

As a result, If I want average by fiscal year of one of the key figures, I am getting that same column for all the periods. Whereas I want to see the individual key figures for each period and then for one key figure I want to see its average for the whole fiscal year period (ONLY ONE COLUMN FOR AVERAGE)

Please let me know if there is a way to do it.

Thank you for going through my query.