Addition in Set Analysis

[#1]

Hi,

I have a pivot chart which contains the fields tabs hr,manager,ceo,sales and count of employees in each tab like below. Now I need to get the Toatl by adding hr.manager,ceo,sales. Could anyone help me how to write by using Set Analysis as previously I entered the vaues by using Set Analysis. But now I could not able to get the addition in Set Analysis

LIST	hr	manager	ceo	sales	Total
case	343	453	45	7
exception	565	5645	567	342
region	676	65	3345	76
crest	45	67	6	8

Thanks.

[#2]

Hi,

I have a pivot chart which contains the fields hr,manager,ceo,sales and count of employees in each tab like below. Now I need to get the Total by adding hr.manager,ceo,sales. Could anyone help me how to write by using Set Analysis as previously I entered the vaues by using Set Analysis. But now I could not able to get the addition in Set Analysis

LIST	hr	manager	ceo	sales	Total
case	343	453	45	7
exception	565	5645	567	342
region	676	65	3345	76
crest	45	67	6	8

Thanks.

[#3]

Hi

Thanks for your answer. I tried it but it is getting  zereos in all rows. Could you let me know why it is like this.

Thanks.

[er_mohit · Accepted solution]

try withot sum() function

column(1)+column(2)+column(3)+column(4)

[#5]

Thanks for you answer Mohit,

Excellent , It's working.