Regarding Pivot tables

I

I Maycotte

Hello everyone,

I've never really worked with pivot tables, but what they do is simila
to what I want with one exception. I don't want it to give me any sum
which it seems to be doing automatically. I was able to hide certai
totals, but is there anyway to turn off that particular aspect (th
summing of values). I hope I wasn't too unclear about this. Thanks.

-- Isaa
 
D

Die_Another_Day

A pivot table must do some function for you. However it can be changed.
Right-click the data and choose field settings. You should be able to
find something more suitable than sum, I usually use max.

HTH

Die_Another_Day
 

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