PIVOT TABLE help
Hi,
How can I use pivot table to reflect my data table in following manner: DATA TABLE item serial abc 110 abc 111 abc 112 abc 114 def 760 def 761 def 762 PIVOT TABLE --------------------------------------- item countofserial start_serial end_serial abc 3 110 112 abc 1 114 114 def 3 760 762 Can calculated fields help? But how do I use em to show the actual serial also in pivot & also pivot will club 'abc' item as 4 & not 3 & 1 as there is a serial missing in sequence. Thanks. |
PIVOT TABLE help
Hi,
This really is not a pivot table problem, you should use a formula approach you can use =COUNTIF(ItemRange,Item) to get the totals for each item you can use the =MAX(IF(ItemRange=Item,SerialRange,"")) and =MIN(IF(ItemRange=Item,SerialRange,"")) These last two are array formulas so you press Shift+Ctrl+Enter to enter them. If this helps, please click the Yes button Cheers, Shane Devenshire "Angela" wrote: Hi, How can I use pivot table to reflect my data table in following manner: DATA TABLE item serial abc 110 abc 111 abc 112 abc 114 def 760 def 761 def 762 PIVOT TABLE --------------------------------------- item countofserial start_serial end_serial abc 3 110 112 abc 1 114 114 def 3 760 762 Can calculated fields help? But how do I use em to show the actual serial also in pivot & also pivot will club 'abc' item as 4 & not 3 & 1 as there is a serial missing in sequence. Thanks. |
All times are GMT +1. The time now is 07:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com