14 Replies Latest reply: Jan 17, 2014 4:08 AM by Shruti Kulkarni

# Total in a column of pivot table

I'm trying to get the sum of all the values of a table in a column but i'm can't get them.

This is my table (and some of my tries...):

Mes and Lab are the dimensions.

What I want, is to get the TOTAL, but in a column.

I was able to get it with the Aggr(Sum(Ventas), Mes), but it only appear in the first row.

Basically, the real thing I want is just to have a column, with the value / total value of that column .

• ###### Re: Total in a column of pivot table

Hi Jose Manuel,

Do not understand much what you want to do, but did you try sth like:

sum(TOTAL Ventas)

?

Fabrice

• ###### Re: Total in a column of pivot table

If I use sum (TOTAL Ventas) I'll get the sum of all the Ventas of all the Mes (Month).

I show a picture:

What I want in the second column intead of 142, is the 30 (the sum of Ventas of that particular Mes)

Something like this:

• ###### Re: Total in a column of pivot table

Then use

Sum(Total <Lab> Ventas).

or

Sum(Total <Mes> Ventas).

• ###### Re: Total in a column of pivot table

use

sum(TOTAL Ventas)

to get total value in ur all column

• ###### Re: Total in a column of pivot table

I'm not sure but have you already tried enabling the properties of showing partial sum.

Chart Properties > Presentation > Show Partial Sum

• ###### Re: Total in a column of pivot table

I've already have the partial sum. Is the last row of the table, but I want them in such a column

• ###### Re: Total in a column of pivot table

Hi Jose,

Could you try this ,

Sum(Total <Lab> Ventas).

• ###### Re: Total in a column of pivot table

With that formula, I get this. 72, 70.

• ###### Re: Total in a column of pivot table

Hi Jose,

Can you post the document with sample data please?

Cheers,

Naresh

• ###### Re: Re: Total in a column of pivot table

This is my script:

t_Ventas:

CrossTable(Mes, Ventas, 3)

Tipo,

Coche,

Enero,

Febrero,

Marzo,

Abril

FROM

[New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Hoja1);

And this is the Excel I'm loading:

 Lab Tipo Coche Enero Febrero Marzo Abril Lab 1 INGRESO SI 12 4 25 6 Lab 1 GASTO SI 4 9 8 4 Lab 2 INGRESO nO 1 5 6 8 Lab 2 GASTO NO 11 13 14 12
• ###### Re: Re: Re: Total in a column of pivot table

hi Jose,

Try this, it is working with " sum(total <Mes> ventas) ".

PFA pic of it.

regards

harshal

• ###### Re: Re: Re: Total in a column of pivot table

hey Jose ,

This is the qvw with changes have a look at it.

regards,

harshal

• ###### Re: Total in a column of pivot table

Hi Jose,

PFA

I tried it and it is working.

use Rangesum(before(sum(ventas),0,2))  to get the desired output .

• ###### Re: Total in a column of pivot table

Hi

Try Using this;

Sum(

(Total <Mes,Tipo> Ventas)

)

HTH

-Shruti