Displaying the median in an SSRS chart

Question

I am developing a bar chart report in SSRS 2008. I simply want the bars in the bar chart to represent the median of a value from the query this is using. What is the best way to do this?

Answer 1

I was able to do this by calculating the median in the query instead of trying to get SSRS to do that for me. I used this to do that in the query: Function to Calculate Median in Sql Server