There is a custom field DIVISION in OBJECTX.
There is a custom field PART NUMBER in OBJECTX.
There is a custom field GROUP in OBJECTX.
The unique key to each record is DIVISION and PART NUMBER.
I would like a report to compare the value of GROUP, across each DIVISION, by PART NUMBER.
So I want PART NUMBER on the Y AXIS, DIVISION on the X AXIS, and the value of GROUP shown in each 'cell'. (No record counts)
Is this type of report available?
6 answers
As you've seen, you can only use Matrix reports with "Summary" data, so you can't get the report you want. You could add the Group as a second level row grouping and show the record counts in each Column.
