I am working with Excel 2002. As I drill into the details of this pivot table from left to right I get the data I expect for the first 3 columns. When I try to get the details for the 4th column, by double clicking on the cell, I get all of the details for anything with the same value in the 3rd column. I am also unclear what behaviour to expect when clicking the headers or the cells and the Hide Detail / Show Detail buttons.
What I ultimately want to do is double click value in column A, display all unique values in column B along with column C (which may have many values the same). At this point I would like to double click into column D and show values in columns E through L.
I am having trouble finding very much information on how the pivot table actually works.
Thanks for any help.
Pat
What I ultimately want to do is double click value in column A, display all unique values in column B along with column C (which may have many values the same). At this point I would like to double click into column D and show values in columns E through L.
I am having trouble finding very much information on how the pivot table actually works.
Thanks for any help.
Pat