Skip to Content
0
Former Member
Sep 15, 2005 at 09:55 PM

Query Output Format

32 Views

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.