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


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 – kunal gupta Mar 25 '16 at 19:29
  • Is there any other way we can display zero values – kunal gupta Mar 25 '16 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 Mar 25 '16 at 19:58
  • Hi @Oleksiy : Actually the report is based on a particular profile. Can I show zero values on graphs – kunal gupta Mar 29 '16 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

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.