Skip to main content
Topics#Reports & DashboardsAmber Gillis の質問
Amber Gillis (K2M) が「#Reports & Dashboards」で質問
2014年8月18日 13:16

Case Report sort by Contact Last Name

Our executive team wants a report/dashboard of all contacts w/ cases.  I have the report and everything looks good EXCEPT they want the contact sorted by last name.  Unfortunately, the report doesn't have teh field "Last Name" as an option though.  Any thoughts on how to creatively do this??

 

The report we're using is Cases w/ Line Items (custom object).
1 件の回答
  1. Sunil Sarilla (M&G Investments)
    2014年8月18日 13:24
    Hi Amber,

     

    one way of doing this is create a formula field called Last Name and get the contacts Last Name (Contact.LastName) into the formula field , make it visible for all users but hide it from all page layouts. Use this formula field to group your report.

     

    If you two different contacts have same last names, Stephen Brown and Stuart Brown, you report stats might not look accurate.
回答を記入...
0/9000