hierarchy

Hi all, Can someone help to have the following table auto-grouped? VBA would be easiest I think. The goal is to have the hierarchy in a good overview people can get to the desired level and fill something in on the columns I will paste next to the table. And therefore Pivot will not work...

I am looking to write some code that will take a flat file and create a child/parent hierarchy from it. The flat file is sorted in order so that each new row is either a new level in the heirarchy or a new child member. This is a sample of the sorted flat file from which the hierarch should be...

Hi team, here is the issue that I have: I read data from multidimensional cube and there is this hierarchy:

Hi all, Someone may have done this before or had some ideas on how to do it so thought I'd check before I dedicated time to it... I have data in a tree and needed to convert it to a '.' separated hierarchy as below. <colgroup><col width="70" span="4" style="width:53pt"> </colgroup><tbody>...

Hi, I am working with a old macro written by someone no longer around (and secondly its not working consistently) I have a reporting Hierarchy that looks like this <tbody> 18615 ,38630,29199,22163,26079,14516,16114,10614 </tbody> I removed the commas and have each ID in its own cell...

Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...

Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...

Hi all, I have a simplified version of a sheet I'm working with below showing the data as it is, and how I'd like it to be.... CURRENTLY... <tbody> Employee Blank Values in Hierarchy Line 1 Manager Line 2 Manager Line 3 Manager Line 4 Manager Employee 1 2 Manager B Manager A...

Hi I am trying to find a way to automatically outline a hierarchy in Excel (group rows) I cannot find a code to do that either For example: <tbody> Code Item Rollup 1 A Title 1.1 B Subtitle Level 1 1.1.1 C Compare 1.2 D Subtitle Level 1 1.2.1 E Subtitle Level 2 1.2.1.1 F Compare...

Greetings, new to the forum. I have a flat .csv file that represents a document with sections and sub sections that will be imported into a requirements management application. This application understands hierarchy, and will recreate it if I can provide a mapping of parent and children rows...

Hi all Using pivottables from olap data sources I often use slicers for filters since end users find it easier. This works great on non-hierarchied dimensions so if for instance I select region-country=canada, then my region-city slicer will only display canadian cities to choose from (due to...

Hello everyone I THINK pivot tables are my answer....but I don't know how to make them work in the way I want :confused: . I am using Excel 2013 on Windows 8.1 I have a database of raw information and essentially I want to be able to produce a Org Structure in a table on a new sheet: - far...

Hi all, New to the forum, so please forgive any newbie mistakes. I have a list of 40,000 unique part numbers, and a seperate database of 500,000 part numbers. The database has many duplicate part numbers, split by Plant (Ownership). The Part/Plant combination on each row is unique, and other...

Hello guys, I have a table that contains how much a client paid for an invoyce ([Valor NF]) and which department received that money. However, my company divides a department in 3 hieararchical levels, which are then represented in the workbook by 3 fields named Dept. Lvl. 1, 2 & 3. Here is my...

I am brand new to the forum and am no expert at excel. I have a MAC Excel 2011 program to work with. I have created a direct selling model that pays commissions based on percentages of sales. I also have partner companies I am working with plus the product distributor. The partner companies (2)...

Hi, I have a workbook that has 6 columns named office, account, exchange, product, and then commision values. Each row is a different commission scheme with not all fields filled out for each scheme; there is a hierarchy. IE lets say the scheme is set at the office level with commision levels...

I have a large flat hierarchy table. I am looking for a method to select a parent and return a list of my lowest level children. I am somewhat familiar with VBA but I don't know where to begin coding this. Thanks so much for any help I am able to receive on this. This has been a great learning...

Hello, I am trying to write a formula that isn't a gigantic IF statement to calculate whether a person has upgraded their type of house or not within a time period. The below are the names of the types of housing. I have two of these lists, the first is from the beginning of the time period...

Hello Everyone I have a list of employees and their managers in excel on Sheet1 (A2 through A? is the employee and B2 through B? is their manager). This goes (so far) up to 8 levels deep. I then have a data validation list that sources column A on sheet1 (The list of employees) that is located...

Hello, I have a table with 1.3+ million records. The table houses account numbers (they can exist more than once), a Field_Data_ID field (is incremental and does not repeat...greatest number is most recent addition), a Description field, START_DT and END_DT both in YYYYMMDD format. My...