Thread: Pivot table
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Pivot table

Hi Arne,

I'm not sure what you mean by "actual table" - is that the pivot table or
the data table? Show a sample of what your pivot table looks like, like this?

Count of Occ.
A 4
B 5
C 6
Total 15

--
Thanks,
Shane Devenshire


"Arne Hegefors" wrote:

Hi! I have a pivot table. In the actual table the data is shown as number of
occurences. Also the automatically created colmn and row "Total" shows the
total sum of the number of occureneces. However I wnat to show number of
occurences in the table and then the mean value at the end instead of total.
but when i try to change this the data in the table also changes. is there
any way to do this? thanks!