Forum Discussion

Marcin's avatar
Marcin
Helper V
7 years ago

Matrix hide blanks

Hi,   I am looking for a solution, for matrix visual .    I have a set of numbers categorised by hierarhy but some of categories has blank name but has some values , like example below for number...
Need Help
Marcin's avatar
Marcin
Helper V
7 years ago

I made a mistake in previous post I have deleted, data sholud look like that :

 

Column1 Column2 Column3 Value
Level1        Level21   Level31    10
Level1        Level21   Level32    15
Level1        Level21                   12
Level1        Level21   Level34    15
Level1        Level22   Level36    15
Level1        Level23   Level37    20
Level1        Level24   Level38    21
Level1        Level24   Level39    24
Level1        Level25                   12
Level1        Level25    Level30   17

 

I am sorry for previous mistake.

 

Regards

 

Marcin 

Marcin's avatar
Marcin
Helper V
7 years ago

This table may also look like this ( additional row at the bottom) where some data have less hierarchy levels and then there are like two blanks categories for one value. 

 

Column1 Column2 Column3 Value
Level1        Level21   Level31    10
Level1        Level21   Level32    15
Level1        Level21                   12
Level1        Level21   Level34    15
Level1        Level22   Level36    15
Level1        Level23   Level37    20
Level1        Level24   Level38    21
Level1        Level24   Level39    24
Level1        Level25                   12
Level1        Level25    Level30   17

Level1                                        45