Hi. I asked this awhile back but didn't receive much feedback. But I'm still dealing with this and am hoping someone can help out.
I have a pivot table with several Value fields. I want multiple calculations to be displayed in the pivot table for that Value...for example, not only do I want "count", but also an average as well as standard dev.
How can I get the final pivot table to display multiple calculations of that Value? I'd rather not have to duplicate that column in the raw data, since I have many columns.
Thanks!
Bookmarks