Matrix Table multi level support

[atpbi10]

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?

[v-xiaotang]

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.

[lbendlin]

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