Hey guys,
I have two pivot table which are created from Power Pivot.
Pivot Table A consists of Manufacturing plant (Row label) and Product Category (Column label) with value field representing whether the particular Product Category from the specific plant is allowed to be exported to a Country destination (Slicer 1). That particular slicer is disconnected to Pivot Table B and I will explain why later
Pivot Table B consists of Manufacturing plant (Row label), Product Data (a tier down in row label) and Country destination (Column label) with value field representing the total no. of existing products (Product Category > Product in terms of hierarchy) in the specific country. (Basically they are existing items being sold in the market). There is also a Slicer 2 which represents the Manufacturing plant and is connected to both tables
The main objective of these 2 tables are:
Overall, when I execute these steps, I want to understand what are the Manufacturing products and its corresponding Product categories that have been approved currently in Norway. Table B allows me to understand what are the other similar products that is currently approved in Norway However there is one big issue.
As such, would it be possible for the Manufacturing Plants in Table B to be automatically sorted when I select Slicer 1? Basically, filtering the Row label in Table B based on the filtered Row label in Table A (which is filtered from selecting Slicer 1).
In addition, could the Slicer 2 only show data from Table A but not Table B although selecting it will filter both tables?
This is quite a complex situation on hand and I'd appreciate any help I could get. Thanks guys!
I have two pivot table which are created from Power Pivot.
Pivot Table A consists of Manufacturing plant (Row label) and Product Category (Column label) with value field representing whether the particular Product Category from the specific plant is allowed to be exported to a Country destination (Slicer 1). That particular slicer is disconnected to Pivot Table B and I will explain why later
Pivot Table B consists of Manufacturing plant (Row label), Product Data (a tier down in row label) and Country destination (Column label) with value field representing the total no. of existing products (Product Category > Product in terms of hierarchy) in the specific country. (Basically they are existing items being sold in the market). There is also a Slicer 2 which represents the Manufacturing plant and is connected to both tables
The main objective of these 2 tables are:
- Select Slicer 1. For example, I have selected Norway
- Pivot Table A will be filtered accordingly and return a list of Manufacturing plant with corresponding Product category that are currently being allowed to be exported to Norway. Pivot Table B will not be affected.
- Slicer 2 is also filtered based on the Manufacturing plants being removed.
- Next, the user will select a specific Manufacturing plant in Slicer 2. The user will know which plant to select by referring to the filtered Table A
- Now we see all the relevant products that are currently being allowed to be exported to.
Overall, when I execute these steps, I want to understand what are the Manufacturing products and its corresponding Product categories that have been approved currently in Norway. Table B allows me to understand what are the other similar products that is currently approved in Norway However there is one big issue.
- Manufacturing Plants in Table A and B are not in sync as the main connection is dependent on the Country destination and Destination slicer is desync to Table B. Both are row labels
As such, would it be possible for the Manufacturing Plants in Table B to be automatically sorted when I select Slicer 1? Basically, filtering the Row label in Table B based on the filtered Row label in Table A (which is filtered from selecting Slicer 1).
In addition, could the Slicer 2 only show data from Table A but not Table B although selecting it will filter both tables?
This is quite a complex situation on hand and I'd appreciate any help I could get. Thanks guys!