I was asked to create a standard report to show data from master-detail object structure.

Sample Data looks like this:

enter image description here

and I am looking to create report as below:

enter image description here

I have tried Matrix report and other options but couldn't get it working.Is this possible?


If the Name field contains only those three types of record then easiest way to accomplish as follows:

Create formula fields

Number of Bedrooms which is type of Number and return the value from Value field.

Number of Bathrooms which is type of Number and return the value from Value field

Floor Type which is type of Text and return the value from Value

Expose those formula fields in the report and then create a simple tabular report the way you have shown in the picture.

  • We have around 10-15 different types. Also, even if I create formula field for each of those, this is how it is showing : imgur.com/a/TWYFMA1 I need only one row in the report. If there is a way to achieve this report without creating formula fields, that would be even better. Thanks for your time. – javanoob Apr 21 '18 at 15:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.