Excel 2000 Pivot Table Calculated Fields
 

Only just moved on to Excel 2000 and I'm having a problem with
calculated fields vanishing from Pivot Tables / graphs. I've attached a
link to a very simplified example of my pivot data to help illustrate.
Each record represents a persons daily attendance, and can be in a
number of states (I've used four in the example, Sick, Meetings, etc
etc etc). A '1' in the relevant column indicates the state (others will
default to '0').

Aim of the pivot is the give an overall percentage for each person over
various time periods. To help with the calculation each record also has
a TOTALCOUNTER field with a value '1' in it (which act as the
denominator part of the equation when I sum it).

I've build calculated fields for each of the four states along the
lines of: PERCENTSICK = SICK / TOTALCOUNTER.

These work out fine and the summary percentages give me the numbers I
want. however If I deselect any of the data elements from the pivot
drop down box, I can't reselect them.

I hope I'm explaining this ok, or not waffling. The example will show
what I mean more clearly - If you deselect %SICK from the DATA drop
down list, you can't select it again. Is there any way to stop this
happening?


http://www.flamingmango.com/tempdump...eldExample.xls

Real version is a lot more involved, and using the STATE / TOTALCOUNTER
calculated field method is the only way it's going to work, but I need
the users to be able to select and deselect the different states at
will. Any help (even if its just to confirm it's not possible) would be
welcome.

Cheers

Lee


--
GreyPilgrim
------------------------------------------------------------------------
GreyPilgrim's Profile: http://www.excelforum.com/member.php...o&userid=31056
View this thread: http://www.excelforum.com/showthread...hreadid=527071