Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 9th 06, 06:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 8
Default I am stupid and don't know what the heck I am doing wrong on this pivot table

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


  #2   Report Post  
Old September 9th 06, 10:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default I am stupid and don't know what the heck I am doing wrong onthis pivot table

Maybe this will do what you want:

Add a new column (LastShip) to the source data, which marks the latest
shipment for each customer For example, with customers in column A, and
dates in column C, enter this formula in cell D2:

=IF(C2=MAX(IF($A$2:$A$200=A2,$C$2:$C$200,"")),"x", "")

Substitute your last row for the 200 in the formula.
This is an array formula. After you type it, hold the Ctrl and Shift
keys, and press Enter.
Copy the formula down to the last row of data.

Refresh the pivot table, and add the LastShip field to the row area.
From that field's dropdown list, leave a check mark only in the X item.

Hide Detail for only that field.

Does that give you the layout that you need?



wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:39 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017