0

I need to create a report in the format which is shown in the screenshot below.

Sample Report Format

In the report, Total No of Notes, Total No of Attachments,Agent Name, Date are all coming from the same object called agent information.

I tried creating a matrix report but i couldn't get it to look like the one which i need.

Matrix Report Format

1 Answer 1

0

You can build this kind of report via Matrix report. In the matrix report, you can group the data by Date at one end and Agent name at the other end. On the group by date, the default is individual date. You can convert that to group by Calendar Week, Calendar Month, Calendar quarter, calendar year, fiscal year, etc. Once this grouping is done, you can then summarize the total no of notes and total no of attachments. You will also need to do hide details.

See below for more info: Creating a matrix report

4
  • I have attached the matrix report which i created. I could not get it to look like the one i need.
    – Ean
    Dec 15, 2016 at 15:40
  • If you want the values side-by-side instead of one-on-top-of-another, you're out of luck. SFDC does not allow that. Dec 15, 2016 at 17:48
  • @Sebastian Kessel Oh! Ok Fine. Is there any possibility to rename the "Sum of TotalCountofInvestorsContacted" to "Total Count of Investors Contacted".
    – Ean
    Dec 16, 2016 at 6:22
  • @Ean Sebastian is right; SFDC does not allow that. Also, I don't think if renaming is possible.
    – RajeshShah
    Dec 16, 2016 at 7:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .