7 Replies Latest reply: Nov 26, 2014 4:03 AM by vinaykumar HG

# calculations of columns

I have this column  that appears in the image

and I want to get the total of all columns

tipo                                       total

1      42+72+48+93  =         255

2       87+2+47+75    =        211

3        86+35+3+61  =         185

another column with the values of total

• ###### Re: calculations of columns

Hi,

If this is your pivot table in QlikView then simply enable the partial sum in presentation tab.

HTH

Sushil

• ###### Re: calculations of columns

Hi,

Enable partial Sum in option in Presentation tab.

Regards,

Jagan.

• ###### Re: calculations of columns

thank you

• ###### Re: calculations of columns

Hi,

Regards,

Jagan.

• ###### Re: calculations of columns

easy way, create one more expression

if ur colulmn names are A,B,C,D

then create new expression =A+B+C+D name it as total.. u can use expression name also for calculation..

• ###### Re: calculations of columns

Can you give me another example, I'm interested that way

• ###### Re: calculations of columns

may be u have

expression 1 as = sum(sales amount) // expression name =sales

expression 2 as = count(oppurtunities) // expression name = oppcount

if u want to calculate avg per oppurtunity (usally this scenario will not araise in sales)

expression 3 = sum(sales amount)/count(oppurtunities)

or

expression 3 = sales/oppcount      // as sales & oppcounts are expression names. this will work also