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.