Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot - top 10 stocks & missing info
i have a lot of stocks with info like GRN date, qty, value, lead time etc.
I used pivot table to consolidate as some items has a few lines because of different GRN dates. (GRN=good received note) - how can the pivot table display the top 10 highest value stocks? If unable, at least display by descending order - anyway to stop the 'lead time' cell going blank? thks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot - top 10 stocks & missing info
Hi,
It may be possible to do what you want but without actually seeing the pivot table or a sample I can't actually say. If you want to send a sample to me OK. If not take a look at these ideas and see if you can use them: Suppose the pivot table has 1 row field called GRP and 1 data field called Value: Double-click the GRP field button in the pivot table and click Advanced, on the right turn on Top 10 AutoShow. Choose either Show of Top or Bottom. Set the number to whatever you want. Open the Using field list and select Value. Click OK twice. To sort the Value field put your cursor in the that field of the pivot table and click the Ascending or Descending sort buttons on the toolbar. Don't have a clue what you mean by "lead time cell going blank" -- Thanks, Shane Devenshire "Christine" wrote: i have a lot of stocks with info like GRN date, qty, value, lead time etc. I used pivot table to consolidate as some items has a few lines because of different GRN dates. (GRN=good received note) - how can the pivot table display the top 10 highest value stocks? If unable, at least display by descending order - anyway to stop the 'lead time' cell going blank? thks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When merging to Word, some info from cell missing? | Excel Discussion (Misc queries) | |||
Missing title, axis, Y info on some charts within a workbook | Charts and Charting in Excel | |||
Missing info in Formula Tab | Excel Discussion (Misc queries) | |||
Missing Pivot Data in Pivot Field (PF)-Weird! | Excel Discussion (Misc queries) | |||
Legend Missing Info | Charts and Charting in Excel |