I am stupid and don't know what the heck I am doing wrong on this pivot table!!!

[ibmapepper]

I used to have a full head of hair until I made my pivot table!! I am
trying to do the following:


Client Name, Last Shipped,Rep,Control #,File #,Grand Total

My list of clients shows all the detail but then when I hide the
detail, the:

Last Shipped
Rep
Control #
File #
are completely blank.


I still have a grand total of the detail, which is great but I am
trying to Show the most recent Last Last Shipped,Rep,Control #,File #,
along with the Grand Total. I am just looking to just show 1 line. This
really nice lady Deb tried to help me but I am completly clueless to
what she wanted me to do.

Tried outlines but when I refresh the data, everything goes out of
wack. I am losing hope and cannot find a solution to this. Please
help!!!

Chris

 

[Tom Ogilvy]

Why not show all the detail and hide the rows you don't want to show by
selecting them on the left edge and do Format=>Rows=>Hide

 

[ibmapepper]

Just tried it again, and what happends is it shows the most current
line but the it truncats 2 more lines from the next customer. Thanks
for your help though. I have been trying to figure this darn thing out
for over a week and I am stumped!

 

[Tom Ogilvy]

if you want to send me the workbook, I will take a look.

(e-mail address removed)

 

[Debra Dalgleish]

Also see answers to your posts in .misc and .worksheet.functions

 

[ibmapepper]

Thanks for the gesture Tom, but I think Debra is on to something. I am
getting closer I think!