MATRIX VALUE NOT SHOW SOME DATA BECAUSE NO RELATED COLUMN

[MagicGianky]

Hi, i have this problem, i have a matrix with DESCRIPTION in a row, sum QUANTITYin values, LOCATIONin column. 

LOCATIONis in cascade relationship  with other 2 table.

Ihave some QUANTITY value taht no have a location, not have a id reationship with LOCATION table.

If i put on a matrix object on total QANTITY value is ok, but on matrix detail i not see QUANTITY not have a location, i expected one column with blank title with this QUANTITY.

Withou LOCATION:

with location

I HOPE I HAVE EXPLAINED IT

[MagicGianky]

Hi @v-yanjiang-msft , if i do this i can see te row but not see value, like my second image.

I need to see this, if i cath all data in one table (is only a test) i can see correct value with no location: 

and this is i need if possible.

thx

[v-yanjiang-msft]

Hi @MagicGianky ,

Please try to select the option "Show items with no data".

Best Regards,
Community Support Team _ kalyj

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