L
Leon Noel
Hi,
I have some data for a pivot table that looks like this
Year ; Messages ; Replies ; Amount
2005 ; 1064 ; 42 ; 100
2006 ; 1064 ; 3 ; 100
As I sent just one set of 1064 messages, I have to avoid summing the
Messages and do a Max(messages).
That way I get 1064 in evey year. Even in the last colum where I get the
total for all the years.
The answer is always 1064.
Now I want the table to calculate the Reply ratio on Messages.
(Like I sent a total of 1064 messages in all and received
42 replies in 2005 - and -
3 replies in 2006).
So I created a data formula in the pivot table to divide Replies by Messages
and display that as a percentage.
But my total is not coming out as I expected in the Total for all the years.
Year 2005 ---- 42 Replies /1064 messages = 3.95 % --- OK
Year 2006 ---- 3 Replies /1064 messages = 0.28 % --- OK
But in the Total I have
45 Replies /1064 messages = 2.11% which is not OK
45 /1064 = 4.23
I can't figure it out.
How ddo I go about getting 4.23% in the Total column ?
TIA
Leon
I have some data for a pivot table that looks like this
Year ; Messages ; Replies ; Amount
2005 ; 1064 ; 42 ; 100
2006 ; 1064 ; 3 ; 100
As I sent just one set of 1064 messages, I have to avoid summing the
Messages and do a Max(messages).
That way I get 1064 in evey year. Even in the last colum where I get the
total for all the years.
The answer is always 1064.
Now I want the table to calculate the Reply ratio on Messages.
(Like I sent a total of 1064 messages in all and received
42 replies in 2005 - and -
3 replies in 2006).
So I created a data formula in the pivot table to divide Replies by Messages
and display that as a percentage.
But my total is not coming out as I expected in the Total for all the years.
Year 2005 ---- 42 Replies /1064 messages = 3.95 % --- OK
Year 2006 ---- 3 Replies /1064 messages = 0.28 % --- OK
But in the Total I have
45 Replies /1064 messages = 2.11% which is not OK
45 /1064 = 4.23
I can't figure it out.
How ddo I go about getting 4.23% in the Total column ?
TIA
Leon