Hi Guys,
I have a question about the format of a query output. The required format is:
Month1 Month2 ... Month12 Total Average
A
B
C
In my query, I have a structure with key figures in the rows section. In the columns section, i have 'Fiscal period'. Below that i have a structure with 2
selections restricted with 'Fiscal Period'(one for Total and other for Average). With this, my output is:
Mth1 Average Mth2 Average... Mth12 Total Average
A
B
C
So, the 'Average' is getting repeated for each month. How can i get the desired output (i.e. with Average only once at the end).
Any help will be greatly appreciated.