I have one table of data. BOM of a truck with parts, purchased, rev, mass, item numbers, weldments, assembly’s, ext. I’m in the process of making an auto update system so when I have a new truck BOM I can just put the data in this table and it will sort and filter. Currently I have a pivot table Named (MOTOR Options) that has a filter in the (Description column) for anything that contains the word (Motor) and a filter in (stock number column) for anything that contains the word (Assembly) all this is saying “you have these motor options in this build”. It gives me two parts ( two motor options), which is correct. Now I want to say in a Pivot table with this motor you need all theses items. So the only way I could think of showing all the parts that go with this motor or that motor is by the item number from the Table of data. So the Item number for motor 1 from (“MOTOR Options” pivot table) is (14.0) and I wanna show motor 1 with all its corresponding item numbers that end up being 14.1-14.27 but I cant set a filter value 0f Great then 14 because the next BOM Motor item number could be 22 or 76. Any comments will help. If there’s a better way let me know I’m all ears. Also is there a way to take my (ASSEMBLYS pivot table) and remove any assembly’s that are in the (MOTOR OPTIONS pivot table ) and (PISTON OPTIONS pivot table is I don’t have (options data) in the (Assembly’s pivot table
Hi Willey! If I understood you correctly, you want to show all item #s (between 14.1-14.27) when you filter for "motor" in the description and "assembly" in stock #. Assuming that the 14.1-14.27 items are associated with motor 1 in your raw data, the 14.1-14.27 are actually a field and not a value. This means that you should put the field "item #" in the Rows box of the PivotTable Fields, not Values. Then you wouldn't need to filter 14.1-14.27. However, if you insist that "item #" must be in the Values box, what you could do is put a random text next to the total column in the your pivot like an "x," click on "Data" in the top banner -> "Filter," which will highlight that total column -> click on the down arrow on the total header -> Filter section: choose one -> between: 14 - 14.99.
Thank you, This was so helpful, with me being from the PC world and recently moving to a Mac
Nice, and you are very soft-spoken keep it up and how can I ask you about any inquiry
Bless you. Reply me
I have one table of data. BOM of a truck with parts, purchased, rev, mass, item numbers, weldments, assembly’s, ext. I’m in the process of making an auto update system so when I have a new truck BOM I can just put the data in this table and it will sort and filter.
Currently I have a pivot table Named (MOTOR Options) that has a filter in the (Description column) for anything that contains the word (Motor) and a filter in (stock number column) for anything that contains the word (Assembly) all this is saying “you have these motor options in this build”. It gives me two parts ( two motor options), which is correct.
Now I want to say in a Pivot table with this motor you need all theses items. So the only way I could think of showing all the parts that go with this motor or that motor is by the item number from the Table of data. So the Item number for motor 1 from (“MOTOR Options” pivot table) is (14.0) and I wanna show motor 1 with all its corresponding item numbers that end up being 14.1-14.27 but I cant set a filter value 0f Great then 14 because the next BOM Motor item number could be 22 or 76. Any comments will help. If there’s a better way let me know I’m all ears.
Also is there a way to take my (ASSEMBLYS pivot table) and remove any assembly’s that are in the (MOTOR OPTIONS pivot table ) and (PISTON OPTIONS pivot table is I don’t have (options data) in the (Assembly’s pivot table
Hi Willey! If I understood you correctly, you want to show all item #s (between 14.1-14.27) when you filter for "motor" in the description and "assembly" in stock #. Assuming that the 14.1-14.27 items are associated with motor 1 in your raw data, the 14.1-14.27 are actually a field and not a value. This means that you should put the field "item #" in the Rows box of the PivotTable Fields, not Values. Then you wouldn't need to filter 14.1-14.27. However, if you insist that "item #" must be in the Values box, what you could do is put a random text next to the total column in the your pivot like an "x," click on "Data" in the top banner -> "Filter," which will highlight that total column -> click on the down arrow on the total header -> Filter section: choose one -> between: 14 - 14.99.