Post reply

Sorting by is not giving the expected results

  • June 2, 2020 at 8:41 am

    #3759310

    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

    11

    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?

    11-22

     

  • June 2, 2020 at 4:38 pm

    #3759430

    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.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

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

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