Home Forums Reporting Services Reporting Services 2008 Development How to total on distinct? RE: How to total on distinct?

  • March 12, 2013 at 1:52 pm

    #1596253

    i might be reading it wrong, but i think you just want to use either a CTE or a subquery, so you can further group your data;

    something like this, maybe?

    SELECT

    [Deposit ID],

    SUM([Deposit Amount]) AS TotalDeposits,

    SUM([Receipt Amount]) AS TotalReceipts

    FROM (SELECT

    DISTINCT

    [Deposit ID],

    [Deposit Amount],

    [Receipt #],

    [Receipt Amount]

    FROM MyTable) MyAlias

    GROUP BY [Deposit ID]

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!