Closed Thread
Results 1 to 2 of 2

Bill Of Material Explosion pivot table

  1. #1
    Registered User
    Join Date
    08-25-2021
    Location
    South Africa
    MS-Off Ver
    office 365
    Posts
    5

    Bill Of Material Explosion pivot table

    I am trying to create a Bill Of Material Explosion pivot table like Diagram1 based on result extracted from a database in sheet 1 called data, my pivot is only going into 2 levels and not showing the multi levels that may go upto 10 levels or more. please see attached sample excel file
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Bill Of Material Explosion pivot table

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread which is in Commercial Services (you must be Guru or above to access threads in CS).
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] aaaaaa
    By hejszyszki in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2021, 06:01 AM
  2. [SOLVED] Calculate Material Release - Bill of Material
    By mgoh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2021, 06:40 AM
  3. Copy down cells with SKU IDs in a Bill-of-Material
    By anasman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2017, 04:45 PM
  4. BOM (Bill of Materials) Explosion
    By AndySimm2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2016, 06:06 AM
  5. general bill of material
    By francesco.ciani88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2015, 02:04 PM
  6. bill of material, assemblies
    By jamesw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2011, 01:53 PM
  7. Multi level Bill of material
    By neorez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2011, 04:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1