Skip to Content
0
Former Member
Mar 04, 2009 at 03:39 PM

Query Designer - Structure - Sub-totals display

385 Views

Hi

I am currently creating a structure with different levels and I woul like to have the subtotal I calculate in the various formulas in the structure below the data and not above like it is now.

For example now :

lvl1Total Net Sales

***lvl2Gross Sales

***lvl2Discounts

What I would like :

***lvl2Gross Sales

***lvl2Discounts

lvl1Total Net Sales

I tried in the query properties/ Row & Colums to change 'result position' but it does not work.

Anyone has a clue ?

Thank you very mucn

Edited by: Nico0 on Mar 4, 2009 4:39 PM