Hello, I am having trouble getting a grand total for my report. One of the fields I would like total up is being displayed in a group header. The value for this field repeats for each row in the detail so my grand total adds up all the repeats. The field is not available in the detail data. I am using the First() function to show it in the group header which works fine but I can't next the First() function inside the Sum() function. Is there anyway to have a grand total for this field that only includes the value 1 time for each group rather than for each detail? Thanks, Matthew

Hi There Thanks for your posting. Can you please have a look on this thread that might help you http://personalinertia.blogspot.co.nz/2008/09/countdistinct-how-about-sumdistinct-or.html However if you are using SSRS 2008 you can also take advantage of using lookup function and get the sum by creating another dataset for your distinct sum values If you have any questions please do let me know Many thanks Syed Qazafi Anjum