function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Manish Kumar 23Manish Kumar 23 

Matrix report

User-added image

Hi All,
Why the values are repeating. I dont want to repeat the value in report. Is there any way to do so
Chandra Sekhar CH N VChandra Sekhar CH N V
Its not a duplicate but the first row just gives you a record count whereas the second gives data related to that record. This is something which can be seen in any matrix report you build.
Manish Kumar 23Manish Kumar 23
Any way of showing only one row?
Tenacious BenTenacious Ben
In the report you have above, you can click on the "Hide Details" button, which will remove the detail rows and only show the Grand Total rows.  This may not be an ideal scenario with real-world data if the end user wants to see how the opportunites tally into the total, but in real-world scenarios, there may be many more opportunites being totaled, so showing details would be preferred.
Manish Kumar 23Manish Kumar 23
Thanks for your inputs. But in this case I need to see closed date and stage also without duplication
Tenacious BenTenacious Ben

Try this: remove the grouping by Opportunity Name that you have configured in that report, leaving only the Account Name as the row grouping.  Then, for your report details, drag the Opportunity Name over to the columns on the right so that it shows as part of each opportunity line item.  Then, you will still have a Grand Total for each account, but each oppoirtunity will be split out line by line.

Configuration:
User-added image
 

Result
User-added image
Tenacious BenTenacious Ben
If any of these answers worked for you, please mark one as the best answer.  If not, post a followup and we'll help as best we can.