拆分数据透视表

ModelEL5求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总YAF250C00005POWERSUPPLY100/240V/250WPS-5221-8AB3632YAS022185100INV(10~14V,VO=850,FOURLAMP)IV40157/T-LF3687总计7319ModelNZ2求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总NAI009162001CAMERACNF916221004171LH(CMOS,1M)3606NAJ00610UG00CPU(938P)AD610EHDK42GM2.4G(PGA)TOPLABS3572NAJ00615RG00CPU(938P)AD615EHDK42GM2.5G(PGA)TOPLABS3565NAS023218102INV(17~21V,VO=1800V,TWOLAMP)TWS-449-3903594总计14337ModelQK3求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总N21TQR200010TQR200OSMW/20AIOSTA200G3ASSY(LSB)3645总计3645ModelQU9求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总N3ZQU9MSLV00QU9MONITORSTANDSUBASSY1456总计1456ModelQUA求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总NAG19063C012ADP19V,6.32A(ADP-120ZBBB)100-240V120W7428NAG19561C039ADP19.5V6.15A(PA-1121-04LI)100V~240V3713NAG19577C005ADP19.5V7.7A(PA-1151-11VA100-240V)3704总计14845ModelQUC求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总N31QUCMB0010QUCMBASSY(512M/DDR3)1.6GCPU2285总计2285ModelWJ1求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总NAD00V224000VGACARD2GBMS-V224-16S3612NAD00V224001VGACARD2GB602-V224-17S3618总计7230ModelWJ2求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总NAD00V267000VGACARD1GB602-V267-01S3620总计3620ModelWJ5求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总NDN095NCV000HEADPHONEBHP-95NCV1133总计1133ModelWJ7求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总NDQ740050801GAMEREMOTECONTROLRCGP400508/02SB1147总计1147ModelWJ9求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总YAJ080280T00ICCTRL(409P)STDP8028-AB(HSBGA)2873总计2873ModelZN5求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescription汇总Y3NZN5TATP20ZN5THERMALMODULEASSY65WUMA(ASV)1443YAA215HW0016LCD(TFT)21.5M215HW01VB(FHD)3528总计4971Model(全部)求和项:ItemNoIfEOLmodel?MaterialNoMaterialdescriptionN21TQR200010TQR200OSMW/20AIOSTA200G3ASSY(LSB)N31QUCMB0010QUCMBASSY(512M/DDR3)1.6GCPUN3ZQU9MSLV00QU9MONITORSTANDSUBASSYNAD00V224000VGACARD2GBMS-V224-16SNAD00V224001VGACARD2GB602-V224-17SNAD00V267000VGACARD1GB602-V267-01SNAG19063C012ADP19V,6.32A(ADP-120ZBBB)100-240V120WNAG19561C039ADP19.5V6.15A(PA-1121-04LI)100V~240VNAG19577C005ADP19.5V7.7A(PA-1151-11VA100-240V)NAI009162001CAMERACNF916221004171LH(CMOS,1M)NAJ00610UG00CPU(938P)AD610EHDK42GM2.4G(PGA)TOPLABSNAJ00615RG00CPU(938P)AD615EHDK42GM2.5G(PGA)TOPLABSNAS023218102INV(17~21V,VO=1800V,TWOLAMP)TWS-449-390NDN095NCV000HEADPHONEBHP-95NCVNDQ740050801GAMEREMOTECONTROLRCGP400508/02SBY3NZN5TATP20ZN5THERMALMODULEASSY65WUMA(ASV)YAA215HW0016LCD(TFT)21.5M215HW01VB(FHD)YAF250C00005POWERSUPPLY100/240V/250WPS-5221-8ABYAJ080280T00ICCTRL(409P)STDP8028-AB(HSBGA)YAS022185100INV(10~14V,VO=850,FOURLAMP)IV40157/T-LF总计拆分数据透视表1，鼠标点选数据表区域内任何一个单元格；汇总2，分析--选项--显示报表筛选页字段--确定3645228514563612361836207428371337043606357235653594113311471443352836322873368764861ModelIfEOLmodel?ItemNoMaterialNoMaterialdescriptionWJ5N1133DN095NCV000HEADPHONEBHP-95NCVWJ7N1147DQ740050801GAMEREMOTECONTROLRCGP400508/02SBZN5Y14433NZN5TATP20ZN5THERMALMODULEASSY65WUMA(ASV)QU9N14563ZQU9MSLV00QU9MONITORSTANDSUBASSYQUCN228531QUCMB0010QUCMBASSY(512M/DDR3)1.6GCPUWJ9Y2873AJ080280T00ICCTRL(409P)STDP8028-AB(HSBGA)ZN5Y3528AA215HW0016LCD(TFT)21.5M215HW01VB(FHD)NZ2N3565AJ00615RG00CPU(938P)AD615EHDK42GM2.5G(PGA)TOPLABSNZ2N3572AJ00610UG00CPU(938P)AD610EHDK42GM2.4G(PGA)TOPLABSNZ2N3594AS023218102INV(17~21V,VO=1800V,TWOLAMP)TWS-449-390NZ2N3606AI009162001CAMERACNF916221004171LH(CMOS,1M)WJ1N3612AD00V224000VGACARD2GBMS-V224-16SWJ1N3618AD00V224001VGACARD2GB602-V224-17SWJ2N3620AD00V267000VGACARD1GB602-V267-01SEL5Y3632AF250C00005POWERSUPPLY100/240V/250WPS-5221-8ABQK3N364521TQR200010TQR200OSMW/20AIOSTA200G3ASSY(LSB)EL5Y3687AS022185100INV(10~14V,VO=850,FOURLAMP)IV40157/T-LFQUAN3704AG19577C005ADP19.5V7.7A(PA-1151-11VA100-240V)QUAN3713AG19561C039ADP19.5V6.15A(PA-1121-04LI)100V~240VQUAN3714AG19063C012ADP19V,6.32A(ADP-120ZBBB)100-240V120WQUAN3714AG19063C012ADP19V,6.32A(ADP-120ZBBB)100-240V120WGAMEREMOTECONTROLRCGP400508/02SBZN5THERMALMODULEASSY65WUMA(ASV)CPU(938P)AD615EHDK42GM2.5G(PGA)TOPLABSCPU(938P)AD610EHDK42GM2.4G(PGA)TOPLABSINV(17~21V,VO=1800V,TWOLAMP)TWS-449-390TQR200OSMW/20AIOSTA200G3ASSY(LSB)INV(10~14V,VO=850,FOURLAMP)IV40157/T-LF