Pivottable, new funtion?

G

Guest

Hi there (sorry for dobbelt posting, was a mistake)

I'm doing a pivottable. In the "values" field, I can choose between
calculating the max, the mean, the standard deviation etc. But is there some
way in which I can define my own funtions? For example, I'd like to calculate
the median?

Another thing: I'd like to make a graph that only uses the numbers in the
pivottable, i.e., it changes when I change the parameters in the table. Is
that possible?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top