pivot table question

[#1]

Hello all,

I’ve been created the following pivot table and I’m knocking my head who to add a new column that will show me the relative value from the total.

below you can see the table that I created.

for example:

I like to take count(if(p=3,t)) / total count(m)  - --- (both marked in red)

Thanks for your help.

[its_anandrjs · Accepted solution]

Hi,

Do a expression like below for the new column

Count( if ( p=3, t ) )

/

Count( total m )

Rgds

Anand

[#3]

thanks a lot.

[its_anandrjs]

Hi,

Hope you got correct or helpful answer from this if so mark it Correct or Helpful so other can see it.

Rgds

Anand

[#5]

one more Q

how i calculate the difference between the bold columns in new column ?

date	S.regionname	hour	category	sum®
2011-10-04	A	19	1	170,930
2011-10-04	A	19	2	17,673
2011-10-04	A	19	3	2,193
2011-10-04	A	19	4	3,051
2011-10-04	A	19	5	2,607
2011-10-04	A	19	6	40,812
2011-10-04	A	19	Total	237,266
2011-10-03	A	19	1	192,166
2011-10-03	A	19	2	28,836
2011-10-03	a	19	3	3,114
2011-10-03	a	19	4	2,928
2011-10-03	a	19	5	2,496
2011-10-03	A	19	6	5,625
2011-10-03	A	19	Total	235,165
Total				472,431