Hi @Nishanth ,
Before that, we need to understand the properties of the Matrix. Matrices provide functionality similar to crosstabs and pivot tables. The number of rows and columns for groups is determined by the number of unique values for each row and column groups.
The following figure shows the initial matrix template, selected on the design surface:
When you drag the fields into the matrix separately, the [Data] displays the sum of the row group and column group crossed, as shown in the figure below:
If you manually change the expression of [Data] to "=Fields!BuildingNO_.Value", you will only get the value of the only row.
As you have done so far, you may add the Building No. field in the row group, as shown in your Figure 2. In your figure, "123", "456", and "789" are displayed in a row, and "987" , "654" is displayed in the second row. What is the basis for this division? What I mean is that there are two values for Type FlatA and FlatB, why not "987", "456", "789" is a row or 987", "654", "789" is a row? As shown in the figure below :
Therefore, the graph we can finally obtain through Matrix will be as shown in your figure two:
I think we cannot determine which row its value appears in for a Type field with two or more values.
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.