| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I am stupid and don't know what the heck I am doing wrong on this pivot table!!!
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 -- Regards, Tom Ogilvy wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I am stupid and don't know what the heck I am doing wrong on this pivot table!!!
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 wrote: 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 -- Regards, Tom Ogilvy wrote in message oups.com... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I am stupid and don't know what the heck I am doing wrong on this pivot table!!!
|
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I am stupid and don't know what the heck I am doing wrong on this pivot table!!!
Thanks for the gesture Tom, but I think Debra is on to something. I am
getting closer I think! Tom Ogilvy wrote: if you want to send me the workbook, I will take a look. -- Regards, Tom Ogilvy wrote in message ups.com... 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 wrote: 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 -- Regards, Tom Ogilvy wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table pulling wrong value | Excel Discussion (Misc queries) | |||
| Pivot Table showing wrong data | Excel Worksheet Functions | |||
| The count on my pivot table is wrong - HELP!! | Excel Discussion (Misc queries) | |||
| I am stupid and don't know what the heck I am doing wrong on this pivot table!!! | Excel Worksheet Functions | |||
| I am stupid and don't know what the heck I am doing wrong on this pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
