cell value of a column by total value of that column.

[#1]

Hi all,

i want to calculate the following in a pivot table:

cell value/(total of column value)

i have attached a pic regarding the explanation of the same.

Thanks for the help,

Regards,

Utsav

[#2]

plan	sum([col 1])	sum([col 2])	(([col 1])/Sum(TOTAL [col 1]))
A	15	5	28.30%
D	10	8	18.87%
G	12	9	22.64%
J	16	2	30.19%
Total	53	24	-

hope this will help you

in this pivot table.. use the expresion i.e

in 4th coloum.

use just use the expression to get in %

and in properties of pivot table select no. and choose fixed to decimal with 2 and click on check box of % to  this field not others...

[#3]

Hi vishwaranjan,

in the [col 1] you specified i have used set analysis as follows:

(sum({$<TableFlag={Contract},[Month (#)]={$(=Max(Month))},Year={$(=num(Max(Year)))}>}WRP_IRDA)/1000000)

I did the same as you suggested but i am not getting the answer. i get null values. i.e "-" in my calculated expression column.

Regards,

Utsav

[#4]

see the attached files

step 1-  open pivot table

step 2-- add dimension  ie plan

step 3--  click on presentation select plan  and the tick mark on partial sum

step 4-- click on expression (1) add expression sum([col 1])

                ( 2) add 2nd expression (([col 1])/Sum(TOTAL [col 1]))

step 5-- then go to number properties of pivot select 2nd expression name the clik on fixed to 2 decimal and then select value in percent

[#5]

Hey thanks again

but the issue i am facing is id i use the label of pivot table in that expression i dont get an answer.

i.e

(([col 1])/Sum(TOTAL [col 1]))

in this if i rename [col 1] as abc in pivot tabel ans use:

((abc)/Sum(Total abc)

it will not give any answer.

[er_mohit · Accepted solution]

hii.

you have to use plan as dimension in pivot table and then in pivot table properties go to

presentation --> in plan field click on partial sum then you get answers...

hope this will help you.

rest of expressions written by vishwaranjan are right.