Spreadsheet: 880737d1728576579-can-a-pivot-table-be-tweaked-to-produce-user-defined-results-which-may-not-be-normal-pkg-data
Sheet: Pivot

L1_SITE_NAME | L1_PRODUCT_NAME | [NAME] | L1_SKU NUMBER | L3_COMPONENT_SUB_TYPE | L3_PACKAGING MATERIAL DESCRIPTION |  | When any particular filter on Column F (in this case "Push through 20um Aluminium hard HSL 7g/m2") is applied, I want the clolumn E (L3_COMPONENT TYPE) to show its corresponding 'Film' results also.  The filter currently gives the result (which is obvious) for all rows where the selection is appearing. However, because any single product (i.e. SKU) will have both film & foil for its blister pack construction. Hence need to explore if there is any way to produce the results where the 'selection' appears but also the corresponding'foil' result also will appear for the SKUs which have the selected entity as 'Foil'
Site 1 | KVE | Abacavir+Lamivudine | P-132196-01 | Film | PVC/PVDC 250/120
Site 1 | KVE | Abacavir+Lamivudine | P-132196-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 1 | VAL | Valaciclovir | P-132327-01 | Film | PVC 300
Site 1 | VAL | Valaciclovir | P-132327-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132328-01 | Film | PVC 300
Site 1 | VAL | Valaciclovir | P-132328-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132333-01 | Film | PVC 250
Site 1 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | LAC | Lacidipine | P-132354-01 | Foil | Cold form 25mmOPA/45mm/60mm
Site 2 | LAC | Lacidipine | P-132354-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 2 | VAL | Valaciclovir | P-132352-01 | Film | PVC 250
Site 2 | VAL | Valaciclovir | P-132352-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132353-01 | Film | PVC 250
Site 2 | VAL | Valaciclovir | P-132353-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132369-01 | Film | PVC 300
Site 2 | VAL | Valaciclovir | P-132369-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | ZOV | Aciclovir | P-132397-01 | Film | PVC/PVDC 250/60
Site 2 | ZOV | Aciclovir | P-132397-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 2 | ZOV | Aciclovir | P-132398-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 3 | MALA | Atovaquone+Proguanil | P-132610-01 | Film | PVC 250
Site 3 | MALA | Atovaquone+Proguanil | P-132610-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 3 | RM | Ropinirole | P-132630-01 | Film | PVC/PE/PVDC 250/25/120
Site 3 | RM | Ropinirole | P-132630-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 3 | RM | Ropinirole | P-132631-01 | Film | PVC/PE/PVDC 250/25/120
Site 3 | RM | Ropinirole | P-132631-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 3 | VAL | Valaciclovir | P-132463-01 | Film | PVC 300
Site 3 | VAL | Valaciclovir | P-132463-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 3 | ZOV | Aciclovir | P-132398-01 | Film | PVC 250
Site 4 | KVE | Abacavir+Lamivudine | P-132196-01 | Film | PVC/PVDC 250/120
Site 4 | KVE | Abacavir+Lamivudine | P-132196-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 4 | LAC | Lacidipine | P-132665-01 | Foil | Cold form 25mmOPA/45mm/60mm
Site 4 | LAC | Lacidipine | P-132665-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 4 | LAC | Lacidipine | P-132666-01 | Foil | Cold form 25mmOPA/45mm/60mm
Site 4 | LAC | Lacidipine | P-132666-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 4 | RM | Ropinirole | P-132632-01 | Film | PVC/PE/PVDC 250/25/120
Site 4 | RM | Ropinirole | P-132632-01 | Foil | [NAME] through CRS Paper/PE/ALU
Site 4 | VAL | Valaciclovir | P-132327-01 | Film | PVC 300
Site 4 | VAL | Valaciclovir | P-132327-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132328-01 | Film | PVC 300
Site 4 | VAL | Valaciclovir | P-132328-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132333-01 | Film | PVC 250
Site 4 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132352-01 | Film | PVC 250
Site 4 | VAL | Valaciclovir | P-132352-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132353-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²