How to calculate Median for each group

• super48

  SSCrazy

  Points: 2682

  More actions

  July 26, 2018 at 11:04 am

  #354784

  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: 183706

  More actions

  July 26, 2018 at 12:00 pm

  #1999146

  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