I have a matrix report where salesforce is ignoring the grand total for 0 values. How can I display the 0 values in grand total.Currently the report is grouped by created date.

Please help!![enter image description here]1


2 Answers 2


I'd have to load a dummy record for each month's period you want to have represented on the report.

*You need to enable Create Audit Fields for the user's profile that will do this data load.

  • hi @Oleksiy : Can you please elaborate I didnot understand Commented Mar 25, 2016 at 19:29
  • Is there any other way we can display zero values Commented Mar 25, 2016 at 19:53
  • 1
    Do you mean that not all 'Created By' users shown on the report? Well, this is an expected functionality - report are using records returned after all filters are applied. You will need to figure out what other filter(s) to add to include all dummy records that can return all list of users you want to have on the report.
    – o-lexi
    Commented Mar 25, 2016 at 19:58
  • Hi @Oleksiy : Actually the report is based on a particular profile. Can I show zero values on graphs Commented Mar 29, 2016 at 19:24

You can create a custom report type using a User as a primary object, and Activity Relationships. Then filter by Activity Created Date, User Profile Name, and any additional filters to make sure you are only looking at Activities related to the object(s) you are interested enter image description here

You must log in to answer this question.

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