Sorting by is not giving the expected results

  • Sam332

    Valued Member

    Points: 64

    Hello, Im new to SSRS and I was trying to order by SUM(linetotal) in my chart but its not working as expected, even though the query looks fine when I execute it in SQL. im using the advantureworks database and below what I have so far


    and this is the results that im getting, the 11,814,376 should be all the way to the bottom if im ordering by Sum(linetotal) Right?



  • Mr. Brian Gale


    Points: 23080

    Looking at your color chart and the way it is ordering it, to me it looks like you are ordering by region (North America, Europe, Pacific) first and by the total second?  You can see where North America - 2 switches to Europe - 10 you have the cost/price going up from 7.8 million to 8.5 million.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply