P
Pepikins
I have created a pivot table with people's names in the ROW, year group
and academic year in the COLUMN and weight/height in the DATA area.
Below is a copy of the pivot table...
Year Group Academic Year
4 5
NAME Data 2004 2005
NAME 1 Height 1.44 1.44
Weight 51.00 51.00
NAME 2 Height 1.44 1.44
Weight 51.00 51.00
The DATA field has a drop down box to filter weight/height but if I use
the filter to only show Height, I cannot get weight back (unless I
undo). Why does the data column not have the same functionality (ie;
show all, filter, then go back to show all) as, say, the NAME column
(ROW field) does? Is there any way I can format the pivot table to
ensure I don't lose all the original selections/fields in the DATA area
if I don't show all? I know I can use SHOW FIELD LIST to put the
selections back in but I don't want to have to re-format each time as
this pivot table will be used by people who do not understand them or
how to reconstruct them.
Thanks for any help.
Pepikins
and academic year in the COLUMN and weight/height in the DATA area.
Below is a copy of the pivot table...
Year Group Academic Year
4 5
NAME Data 2004 2005
NAME 1 Height 1.44 1.44
Weight 51.00 51.00
NAME 2 Height 1.44 1.44
Weight 51.00 51.00
The DATA field has a drop down box to filter weight/height but if I use
the filter to only show Height, I cannot get weight back (unless I
undo). Why does the data column not have the same functionality (ie;
show all, filter, then go back to show all) as, say, the NAME column
(ROW field) does? Is there any way I can format the pivot table to
ensure I don't lose all the original selections/fields in the DATA area
if I don't show all? I know I can use SHOW FIELD LIST to put the
selections back in but I don't want to have to re-format each time as
this pivot table will be used by people who do not understand them or
how to reconstruct them.
Thanks for any help.
Pepikins