Forum Discussion

atpbi10's avatar
atpbi10
Helper I
4 years ago

Matrix Table multi level support

I have the following dataset in following form:

 

Level 1           Level 2            Level 3        some value

Gross Profit   Revenue A      Product A         2

Gross Profit   Revenue B       Product A        3

EBIT              EBIT A            Product A          4

EBIT              EBIT B           Product C           5

EBIT              EBIT B          Product B            6

 

I am trying to create simple matrix table that has expandable rows based on level hierarchy. Somehow when I just put those three columns Leve 1, Level 2, Level 3 I cant get this to work properly:

 

Any idea what might be wrong and why im getting Level 1 value multiple times one for each level 2 value below, instead of SINGLE level 1 that woudl expand onto level 2 values and so on?

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Your screenshot doesn't match your sample data.  Please show expected outcome based on the provided sample data (or provide more comprehensive sample data).

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi atpbi10 

    The result bellow is correct according to the sample you shared, I cannot reproduce that behavior with your sample data, please provide a sample file with that behavior, thanks. Also, you can change the data type to text and test again.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.