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

  63. cipro pharmacy [url=]buy ciprofloxacin[/url] purchase cipro

  64. prednisone for sale in canada [url=]prednisone buy without prescription[/url] apo prednisone

  65. best ed pills [url=]erection pills online[/url] medicine for impotence

  66. top 10 pharmacies in india [url=]Online medicine order[/url] cheapest online pharmacy india

  67. ed pills for sale [url=]erection pills online[/url] best ed pills non prescription

  68. where to buy generic propecia tablets [url=]buy propecia[/url] can you buy cheap propecia for sale

  69. can i order cheap propecia [url=]Finasteride prescription online[/url] how can i get generic propecia pill

  70. Kamagra Oral Jelly for sale [url=]Kamagra Gold 100mg price[/url] buy kamagra online

  71. Kamagra Oral Jelly 100mg buy online [url=]Kamagra 100mg[/url] Oral Jelly 100mg Kamagra price

  72. [url=][/url]

    Принципиальные членения на сайте 1carry off the palm casino: Remain – экстензо актуальных происшествий, на каковые предлагается сделать ставку.
    one win casino

  73. Oral Jelly 100mg Kamagra price [url=]Kamagra 100mg[/url] Kamagra Gold 100mg price

  74. Kamagra Oral Jelly 100mg buy online [url=]buy kamagra online[/url] Oral Jelly 100mg Kamagra price

  75. buying prescription drugs in mexico [url=]purple pharmacy mexico price list[/url] purple pharmacy mexico price list

  76. mexico drug stores pharmacies [url=]buying from online mexican pharmacy[/url] pharmacies in mexico that ship to usa

  77. buy medicines online in india [url=]cheapest online pharmacy india[/url] top 10 online pharmacy in india

  78. Online medicine order [url=]indianpharmacy com[/url] online pharmacy india

  79. indian pharmacy [url=]reputable indian online pharmacy[/url] online shopping pharmacy india

  80. online pharmacies without an rx [url=]legitimate canadian mail order pharmacies[/url] best canadian online pharmacy reviews

  81. certified canadian international pharmacy [url=]safe online pharmacy[/url] my canadian pharmacy

  82. over the counter birth control pills [url=]birth control pills cost[/url] п»їbuy birth control pills online

  83. best canadian pharmacy to buy from [url=]certified canadian pharmacy[/url] my canadian pharmacy rx

  84. indian pharmacies safe [url=]Online medicine home delivery[/url] п»їlegitimate online pharmacies india

  85. top 10 pharmacies in india [url=]п»їlegitimate online pharmacies india[/url] reputable indian online pharmacy

  86. mexico drug stores pharmacies [url=]purple pharmacy mexico price list[/url] mexican online pharmacies prescription drugs

  87. [url=]buy lisinopril without prescription[/url] how to buy lisinopril

  88. [url=]certified canadian pharmacy[/url] canadian pharmacy 24h com safe

  89. [url=]certified canadian pharmacy[/url] canadian pharmacy online store

  90. stromectol cream [url=]stromectol tablets 3 mg[/url] ivermectin 1%

  91. what’s the best online pharmacy [url=]onlinepharmaciescanada com[/url] online pharmacy non prescription drugs

  92. buy medicines online in india [url=]online pharmacy india[/url] best india pharmacy

  93. Nie zachęcam nikogo do spędzania długich, mroźnych, zimowych wieczorów w kasynie. Polecam za to tę grę jako przyczynek do zastanowienia się nad teorią przypadkowości albo po prostu ? jako dobrą zabawę w gronie kilku miłych osób. W końcu (na szczęście) nigdzie nie jest powiedziane, że musimy grać na pieniądze. Ruletka francuska jest najstarszą i prawdopodobnie najciekawszą formą ruletki ze względu na dodatkowe opcje i zasady obstawiania. Ruletka francuska, spośród wszystkich innych wariantów ruletki, ma również najniższą przewagę kasyna, co czyni ją najbardziej atrakcyjną wersją ruletki pod względem zysków. Zaleca się więc by choć raz zagrać w tę wersję ruletki. Casino ruletka z francuskiego to dosłownie małe koło. Popularność gry ruletka z kasyn naziemnych szybko przeniosła się do internetu. Od tego momentu możesz zagrać w ruletkę bez wychodzenia z domu o każdej porze. Gra ruletka on line znajduje się w każdym kasynie internetowym. W jednym miejscu możesz wybrać różne odmiany ruletki, za jaką stawkę zagrasz lub czy ma to być darmowy symulator ruletki.
    Content Type Digital Magazine Elenite – letnisko znalazło swoje miejsce w spokojnej zatoczce z ogromną plażą położoną pośród zielonych łąk. Nowoczesne ośrodki wypoczynkowe zapewniają aktywne spędzanie czasu oraz dysponują szeroką ofertą atrakcji zarówno rozrywkowych, jak i rekreacyjnych. W wąskich i zacienionych uliczkach nawiązujących architektonicznie do Nesebyru, można spędzić niezapomniane chwile, przysłuchując się jednocześnie rozmowom miejscowych rybaków. Retail and Wholesale Od obywateli polskich na terenie Kuby wymagane są wizy uprawniające do wjazdu i pobytu lub tzw. karty turystyczne (Tarjeta de Turista), które można otrzymać wraz z dokumentami podróży oferowanymi przez poszczególne biura. Taką kartę podstemplowaną przez oficera służby granicznej należy mieć przy sobie podczas pobytu na Kubie, a także podczas opuszczania wyspy. Jeżeli planuje się zostać na wyspie dłużej niż 30 dni, istnieje możliwość przedłużenia wizy o miesiąc. Okres ważności paszportu musi być dłuższy niż 3 miesiące od planowanej daty powrotu.

  94. п»їlegitimate online pharmacies india [url=]Online medicine home delivery[/url] top online pharmacy india

  95. canada pharmacy reviews [url=]certified pharmacy canada[/url] canadian pharmacy online

  96. reputable indian online pharmacy [url=]online shopping pharmacy india[/url] top 10 pharmacies in india

  97. Fine posts. Regards!
    [url=]best essay writing service[/url] essaytyper [url=]essay typer[/url] argumentative essay

  98. cost of generic propecia without prescription [url=]cheap generic propecia[/url] buy cheap propecia online

  99. Nicely put, Appreciate it!
    [url=]define dissertation[/url] dissertation writing services reviews [url=]dissertation[/url] phd paper

  100. propecia otc [url=]Buy Finasteride online[/url] cost propecia without insurance

  101. With thanks! Good information!
    [url=]phd dissertation[/url] phd paper [url=]dissertation abstracts international[/url] dissertation abstract

  102. You have made your point pretty effectively!.
    [url=]can you do my homework[/url] should i do my homework [url=]cpm homework[/url] i don t want to do my homework

  103. Cheers! Awesome information!
    [url=]thesis binding[/url] thesis sentence [url=]strong thesis statement[/url] tentative thesis

  104. You stated that fantastically!
    essay writing service usa [url=]legitimate essay writing service[/url] essay writing prompts

  105. how can i get mobic online [url=]can i buy cheap mobic without prescription[/url] cheap mobic without dr prescription