Hi there,

I am trying to get mean, mode and median averages into the same pivot chart. This is causing me problems!

Basically, I pull in mean and change the calculation to average - fine.

Then I pull in median or mode, and it automatically goes to 'sum of 'median', while still displaying the average for the mean. At this point my variables turn into a 'data' field and then I cannot edit the field properties or axis labels.

How would I go about this? Thanks in advance,

Russell