How to calculate Median for each group

  • super48

    SSCrazy

    Points: 2682

    How can i calculate median in SSRS for each group.
    i have created custom vb code but for each group its taking all the values in dataset.
    not group wise.

  • Luis Cazares

    SSC Guru

    Points: 183581

    super48 - Thursday, July 26, 2018 11:04 AM

    How can i calculate median in SSRS for each group.
    i have created custom vb code but for each group its taking all the values in dataset.
    not group wise.

    Would it help if you get them in your query? This article shows how. http://www.sqlservercentral.com/articles/T-SQL/173367/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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