Forum Discussion
Combine Rows in a Matrix Table
Help I want to combine quantity rows into one row. For Example (What I know): If selected BatchNo is Batch-202 & Batch-203. I will take the (Max) ActualValue for each BatchNo then Sum it and ...
Hi Luthulis ,
If I understand correctly, you're trying to combine two rows of data with label Quantity and brand no. Batch-202 & Batch-203 into one row. I reviewed your file and you put the field [ActualValue] on the Rows option of Matrix. I'm afraid I won't be able to fulfill your needs. The field which can be put on Rows option of matrix is a fact field or a calculated column. Since it is a fact field or calculated column, then there is no way to dynamically display the value. Perhaps you might consider creating a measure that calculates the actual value based on your criteria and then putting it in the value column. The problem with this is that the values of all labels are combined and appear under each package label...
Best Regards