Creating Hierarchy table with string column as value.

[anilreddy128]

Hi,

I need to create a hierarchy display to show some comments of a function and metrics in each function.

Table would look like below. I need to show all functions in level hierarchy and their comments. When user expands hierarchy, corresponding metrics comments should be displayed. Tried using matrix and table but looks like something is missing for me.

Any ideas??

Thanks,

Anil

Function	Metric	Metric Comments	Function Comments
Product Quality	Design Maturity Metric at release (%) (Phase V from stoplight chart) (AIT)	comments 1	comments_function1
Product Quality	Design Maturity EVM Release Readiness Review at release (Phase IV plm release criteria)	comments 2	comments_function1
Product Quality	QTP Coverage/Failures	comments 3	comments_function1
Product Quality	SRE arrivals	comments 4	comments_function1
Product Quality	Total # of defects per product  (# FW bugs) at release (EVM)	comments 5	comments_function1
Product Quality	Total # of defects SBM (# FW bugs submitted most recent 6 mo period) (AIT)	comments 6	comments_function1
Product Quality	SPR's resulting in EC's	comments 7	comments_function1
Product Quality	Field BUGs from Customer Complaints (# bugs submitted most recent 6 mo period) (AIT)	comments 8	comments_function2
Product Quality	Field/Warranty Failure Rate EVM (%) ( x100 to give range of response)	comments 9	comments_function2
Product Quality	NA w/UPS Field/Warranty Failure Rate AIT (%/mo) (x100 to give range of response)	comments 10	comments_function2
Supply Chain Quality	DC Delivered Quality (Over / Under ships) - PPM	comments 11	comments_function2
Supply Chain Quality	Customer External PPM (DOA)	comments 12	comments_function2
Supply Chain Quality	Rolled First Time Yield (%) 1-(1-B)*10	comments 13	comments_function2
Supply Chain Quality	Tier 1 Forward Looking Metric (JDM, GCM, etc) (0-5 scale convert to %) (Value is 5-"B"  used in RC equation)	comments 14	comments_function2
Supply Chain Quality	Tier 2 Forward-Looking Metric (component suppliers) (0-5 scale convert to %) (Value is 5-"B"  used in RC equation)	comments 15	comments_function2
Supply Chain Quality	Critical Issues/Stop Ships (Incident/Week)	comments 16	comments_function2
Supply Chain Quality	QMS Audit Compliance (Zero major non-conformances; 3 or fewer minor non-conformances per site)	comments 17	comments_function2

[anilreddy128 · Accepted solution]

I need to create some thing like below.

function name	function comments
metric name	metric comments
metric name	metric comments

function comments and metric comments are in separate columns in table.

Thanks,

Anil

[v-frfei-msft · Accepted solution]

Hi @anilreddy128 ,

As @pa_trick67  said, Matrix should help you.

[v-frfei-msft · Accepted solution]

Hi @anilreddy128 ,

As @pa_trick67  said, Matrix should help you.

[pa_trick67]

Hi @anilreddy128 

Could you be more specific on what you want?

Normally a matrix can be do that.

Patrick

[anilreddy128 · Accepted solution]

I need to create some thing like below.

function name	function comments
metric name	metric comments
metric name	metric comments

function comments and metric comments are in separate columns in table.

Thanks,

Anil

[pa_trick67 · Accepted solution]

Hi @anilreddy128 

Is that fit your need?