SSRS 2008 Total of a Group

Posted on 2011-10-26
Last Modified: 2012-05-12
On the line labeled "Total" I'm trying to get a total of the group but I keep getting the total of the entire dataset not what actually appears in the report from the Top N in the StoreGameID group filter. Their has to be something I'm missing. This seems pretty standard.
 Tablix Row Groups
Question by:dk04
    LVL 10

    Accepted Solution


    With your current arrangment you will get total of dataset as expresion is outside the groups, however you might be able to SUM based on text boxes name. See below syntax


    Hope that helps


    Author Comment

    With your Syntax I received the following error- Aggregate functions can be used only on report items contained in page headers and footers.

    Is their a better arrangement I should have?
    LVL 10

    Assisted Solution

    It seems I cannot find a way to use aggregate function on a group with Top N and normal function compeltelly ignore top n. The only option I can think of now is to limit the result in dataset instead of the group.


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now