Mean and Median in SSRS Reports



Let us discuss about “How to show MEAN and MEDIAN” of a series in a chart in this post. This post is specially for those who doesn’t know that there is an option available in SSRS to show MEAN and MEDIAN in reports. To demonstrate the same lets us take a simple query from Adventure Works database. This query pulls Product wise sales from the database. PFB the query –

SELECT Top 30 DimProduct.EnglishProductName, SUM(FactInternetSales.SalesAmount) AS Sales
FROM FactInternetSales INNER JOIN
DimProduct ON DimProduct.ProductKey = FactInternetSales.ProductKey
GROUP BY DimProduct.EnglishProductName

To make the report look better, I am pulling ONLY top 30 records from the database.

Now create a “Dataset” in SSRS report using the above query.

Now take a line chart from ToolBox and drag and drop EnglishProductName to “Category Fields” and Sales to “Data Fields” of Line chart as shown in below pic.

Now Right click on “Sales” which is added to “Data Fields” and select “Add Calculated Series” option.

Select “Mean” from the dropdownlist next to label “Formula” and select OK.

Repeat the last TWO steps and add MEDIAN to the Line chart. Now click on PREVIEW to preview your report. You can see MEAN and MEDIAN series added to your chart.

That’s it .. It is as simple as this. Hope you understood and Happy coding !!


Roopesh Babu V


  1. Cheers! An abundance of advice.
    [url=]college application essay help[/url] how to write a college essay [url=]essays help[/url] common application essay help

  2. You said it well.
    [url=]reliable essay writing service[/url] home visit will writing service [url=]writing service essay[/url] college essay writing service

  3. Nicely put. Thank you!
    [url=]writing a college application essay[/url] essay service review [url=]resume writing service new york[/url] english literature essay writing service

  4. [url=]займ на карту без отказа[/url]

    Изберите подходящий ссуду сверх отказа на одной изо 79 компаний. В ТЕЧЕНИЕ каталоге 181 предложение с ставкой от 0%. Сверху 22.03.2023 удобопонятно 79 МФО, экспресс-информация числом …
    займ на карту без отказа

  5. You actually explained it very well!
    [url=]buy college essays online[/url] order your essay [url=]pay to get an essay written[/url] essay writer pay

  6. You stated this effectively!
    [url=]help me do my homework[/url] will you do my homework [url=]i didn t do my homework form[/url] do my english homework for me free

  7. Valuable tips. Kudos!
    [url=]writing a persuasive essay[/url] cheap essay writing service australia [url=]best military to civilian resume writing service[/url] best paper writing service reviews

  8. Nicely put, Appreciate it.
    [url=]best resume writing service 2016[/url] economics essay writing service [url=]unite will writing service[/url] best australian essay writing service

  9. Regards! I appreciate this!
    [url=]buy a dissertation online[/url] phd thesis writer [url=]dissertation help service london[/url] help with dissertations

  10. Terrific facts. Many thanks.
    [url=]do my geometry homework for me[/url] have someone do my homework [url=]do my english homework for me[/url] i tried to do my homework by kenn nesbitt

  11. ed medications online [url=]ed medicine online[/url] buy prescription drugs from canada cheap

  12. Great data. Thanks a lot.
    [url=]essay writting[/url] cheap assignment writing service [url=]writing an expository essay[/url] college essay writing service

  13. Seriously all kinds of awesome facts!
    [url=]writing essay[/url] writing an informative essay [url=]essay write service[/url] term paper writing services

  14. Wow plenty of excellent data.
    [url=]thesis topic[/url] research thesis [url=]thesis in an essay[/url] service quality thesis philippines

  15. You said it nicely.!
    [url=]help with writing essays[/url] essay writing service law [url=]essays writing help[/url] essays help

  16. viagra online spedizione gratuita [url=]viagra online spedizione gratuita[/url] viagra ordine telefonico

  17. Beneficial knowledge. With thanks!
    [url=]professional dissertation help[/url] doctoral dissertation [url=]buying dissertation[/url] dissertation writing online

  18. You said it adequately..
    [url=]dissertation writers[/url] custom dissertation writing [url=]phd dissertation writing[/url] top dissertation writing service

  19. Awesome facts. Thanks!
    [url=]buy a research paper online[/url] term paper writing service [url=]research proposal writer[/url] research paper proposal

  20. Very good material. Thanks a lot!
    [url=]dissertation consulting[/url] phd paper [url=]dissertation online help[/url] write my dissertation

  21. Regards! I like this.
    [url=]college thesis[/url] phd thesis database [url=]thesis writing[/url] thesis proposal example

  22. Thank you! A good amount of posts.
    [url=]online essay writing services[/url] essay writing topics in english [url=]grad school essay writing service[/url] writing a college essay

  23. Step 7 Place the TOBI Podhaler capsule in the capsule chamber at the top of the Podhaler device right away See Figure K effets indesirables levitra A placebo controlled double blind pilot study comparing the prophylactic use of phenethicillin with a placebo in buccal bone grafting procedures found a high infection rate 40 at the receptor site in the placebo group

  24. This is nicely said! .
    [url=]cheap paper writing service[/url] essay writting service [url=]linkedin writing service[/url] resume writing services

  25. Thank you, Awesome information!
    [url=]college thesis[/url] thesis [url=]writing a thesis statement[/url] college thesis

  26. You said this really well.
    [url=]writing a paper[/url] paper writer online [url=]professional paper writers[/url] pay to write paper

  27. Kudos, I value this!
    [url=]phd thesis[/url] writing dissertation [url=]phd weight loss[/url] phd thesis

  28. Very good content, Thanks.
    [url=]essay writers[/url] essay writer website [url=]website that writes papers for you[/url] online essay writer

  29. Regards. Lots of info!
    [url=]write my essay for free[/url] write my essay [url=]writing an opinion essay[/url] write my essay for me free

  30. top online pharmacy india [url=]india pharmacy mail order[/url] best online pharmacy india

  31. mexican online pharmacies prescription drugs [url=]mexico drug stores pharmacies[/url] mexican border pharmacies shipping to usa

  32. Awesome content. Thank you.
    [url=]writing a paper[/url] essay writter [url=]pay for paper[/url] pay someone to write a paper

  33. With thanks. Quite a lot of facts.
    [url=]pay for research paper[/url] pay someone to write paper [url=]cheap research paper writing service[/url] pay someone to write your paper

  34. Great posts. Thanks!
    [url=]thesis[/url] a thesis [url=]thesis paper[/url] thesis writing

  35. Useful forum posts. Kudos.
    [url=]pay for paper[/url] buy essay [url=]pay for papers[/url] pay for essay papers

  36. Good facts. Thanks.
    [url=]writing dissertations[/url] dissertation definition [url=]buy dissertations[/url] dissertation data analysis help

  37. Cheers, Awesome stuff.
    [url=]writing papers[/url] write my paper for cheap [url=]writing paper[/url] writing a research paper

  38. Wonderful advice. Appreciate it.
    [url=]where to buy essays online[/url] pay for an essay [url=]pay to write essay[/url] buy an essay online

  39. buying drugs canada [url=]online pharmacies no prescriptions[/url] canadian drug stores

  40. top rated online canadian pharmacies [url=]canadian meds without prescription[/url] online discount pharmacy

  41. cheap drugs canada [url=]canadian online pharmacies ratings[/url] canadian pharcharmy reviews

  42. Thanks. Useful stuff.
    [url=]affordable essay writing service[/url] writing service essay [url=]essay writing samples[/url] best research paper writing service

  43. Thanks, Very good information!
    [url=]help me write my essay[/url] paper writing help [url=]free writing assistant[/url] free writing assistant

  44. india pharmacy [url=]п»їlegitimate online pharmacies india[/url] reputable indian online pharmacy

  45. Omni Slots Casino was opened in 2015. Not so much time has passed by, but they managed somehow to create a space which is completely filled with huge variety of promotions, VIP possibilities and quality games. Not to mention their friendly support and very serious security and privacy systems! 🔥 Welcome bonuses are offered by online casinos to new players in order to motivate them to open an account and play. Welcome casino bonuses include no deposit bonuses, deposit bonuses, and more. Keep reading to learn more about registration bonuses offered by Omni Slots Casino. Best Online Casino Games #231438352 (no title) #231438397 (no title) Bonuses for Online Gambling: How You Can Maximize Your Profit; Free Demo Slot Games Can Help You Improve Your Slots; No Deposit Casino Bonus. Regular No Deposit Bonus. This bonus gives you a certain amount of free cash or casino credits to play with. This is usually a limited amount, anywhere between R50 and R300. You can use the bonus to play games of your choice, though some casinos limit the usage of the bonus to specific games only.
    Judi slot online memiliki banyak pilihan menguntungkan bagi pemain slot salah satunya adalah slot dengan RTP tinggi. Fitur Return to Player akan memberikan pemain tambahan dana bertaruh karena mengembalikan beberapa persen modal betting yang dimiliki oleh pemain. Selain itu, melihat angka RTP dari permainan slot online juga akan membantu memili slot gacor dengan kecepatan kemenangan baik dan kemampuan membayar paling menguntungkan. Beberapa pilihan slot dengan angka RTP tinggti adalah sebagai berikut: Situs Slot terpercaya Master138 memberikan jackpot slot online ratusan juta setiap hari membuat banyak player menanti untuk mendapatkan kemenangan tersebut Populer game disaat ini yang bisa dimainkan oleh tua dan muda mudah dimengerti dimana tujuan utama dimana harus memiliki gambar yang sama untuk slot online mendapatkan hadiah yang berlipat-lipat dinamakan Jackpot.

  46. Terrific information. With thanks.
    [url=]press release writing service[/url] online essay writing [url=]admission essay service[/url] last minute essay writing service

  47. Wow loads of helpful material!
    [url=]thesis statements[/url] define thesis statement [url=]research thesis[/url] thesis writing

  48. Truly lots of excellent info!
    [url=]buy an essay[/url] pay for essays [url=]pay for essays[/url] pay for essay reviews

  49. Kudos! Valuable stuff!
    [url=]best essay writing service[/url] writing helper [url=]essaypro[/url] buy essay

  50. Amazing information. Many thanks.
    [url=]best essay writers[/url] write my essay online [url=]writing essays for money[/url] writing essays

  51. non prescription erection pills [url=]cheapest ed pills online[/url] non prescription ed pills

  52. Amazing a lot of superb information.
    [url=]phd thesis[/url] dissertation abstracts [url=]dissertation writing services[/url] phd dissertation help

  53. canadian pharmacieswith no prescription [url=]licensed canadian pharmacies[/url] meds online without doctor prescription

  54. canadian rx [url=]order prescription medicine online without prescription[/url] online ed drugs no prescription

  55. [url=]уборка складов[/url]

    Уборка склада. Эскапизм за складом подсобляет неважный ( чуть только сберечь целомудрие, хотя также создать условия нужные условия чтобы сбережения продукции. Мы поддержим идеально уничтожить …
    уборка складов

  56. Truly tons of wonderful knowledge.
    [url=]research proposal apa[/url] research paper writers [url=]buy a research paper[/url] research paper writers

  57. top rated canadian pharmacies [url=]legitimate canadian mail order pharmacies[/url] online drugstore coupon

  58. Many thanks! Numerous knowledge.
    [url=]cheap essay service[/url] types of essay writing [url=]cheap custom essay writing service[/url] service essay

  59. cialis original online [url=]cheap cialis[/url] cialis price comparison no prescription

  60. Good postings. Regards!
    [url=]paper writing services[/url] buy essay online writing service [url=]best online essay writing service[/url] writing a narrative essay

  61. cialis цена [url=]buy Tadalafil 20mg[/url] cost of cialis 20mg

  62. what happens if a woman takes viagra or cialis [url=]cialis professional review[/url] cialis professional 20 lowest price


Please enter your comment!
Please enter your name here

81 − 73 =