Analysis Studio Cognos 8. Just wanting to put a sub-total inbetween coloumns

[will8044]

Hi All,
I have built a table within Analysis Studio with Coloumns being Assets Liabilities & General. Now i would like a sub-total of Assets & Liabilities to sit within Liabilities & General though when i do this the coloumns Total goes to the far Right. Is there any way i can get this sub-total coloumn to fall inbetween Liabilities & General. Would really appreciate all the help.

Cheers
WILL

[goose]

If I understood your query correctly you can do what you want kinda. Have a look at the attached picture. In order to get 'Store Intake + Sales' "between" the last measure you must do this.

1. Add Store Intake and Sales as columns

2. Add a total for them or a calc I used a calc in the example

3. Then select the measure list in the columns section of the toolbar

4. Right click Reg Sales from insertable objects on the left

5. From the context menu select Insert -> After Selected  Set

You should then have the subtotal between the columns

Good Luck!

[will8044]

Hey Angus,
Thanks again for your reply & help much appreciate this. I will give it a go hopefully i get it. Thanks again.

Cheers
Will