how to sum the rows in a table

[arezoo99]

Hi,

i want to show the total of each rows for the two senarios below:

1. total of all dimentions for each manager

         SUM(Product A,Product B,Product C,Product D,Product E,Product F,Product G,Product H,Product 1)

2. Total of selected dimentions for each manager

       SUM(Product A,Product C,Product E,Product H)

would you please advise how i can do that

Manager Name	Product A	Product B	Product C	Product D	Product E	Product F	Product G	Product H	total of all dimentions per manager	Sum of Product A, C,E,H Per manager
Aiden	31	8	12	27	14	25	14	25	156	82
Tom	37	211	35	213	38	210	58	190	992	300
Anthony	4	60	1	63	1	63	1	63	256	69
Mark	22	70	21	71	22	70	20	72	368	137
Edward	12	56	11	57	11	57	11	57	272	91

[Anonymous]

Hi Arezoo99 

           I would recommend you change your data-set from Columns to Rows. For example you can use the Cross-table Wizard in the Load script to transpose your product columns into rows. 

Current Data Set

Current Data View
Manager Name	Product A	Product B	Product C	Product D	Product E	Product F	Product G	Product H
Aiden	31	8	12	27	14	25	14	25
Tom	37	211	35	213	38	210	58	190
Anthony	4	60	1	63	1	63	1	63
Mark	22	70	21	71	22	70	20	72
Edward	12	56	11	57	11	57	11	57

Proposed View. (Using Cross Table Wizard)
Manager Name	Product Grouping	Product Amount
Aiden	Product A	31
Aiden	Product B	8
Aiden	Product C	12
Aiden	Product D	27
Aiden	Product E	14
Aiden	Product F	25
Aiden	Product G	14
Aiden	Product H	25
Tom	Product A	37
Tom	Product B	211
Tom	Product C	35
Tom	Product D	213
Tom	Product E	38
Tom	Product F	210
Tom	Product G	58
Tom	Product H	190

Once the data is reloaded, this will allow you to use set analysis to easily total and sub total your products by manager.

Recommended Chart: Pivot Chart

1. total of all dimensions for each manager

          SUM(Product Amount)

       2. Total of selected dimensions for each manager

       SUM( {$< [Product Grouping] = {'Product A', 'Product B', 'Product C'} >} [Product Amount])

Let me know if the above is of any help.

Cheers