question

TelepathicSheep2 avatar image
TelepathicSheep2 asked

SSRS 2008 Reporting Question - Include 'month' filter in YTD Calculation

Hey all, Here's my situation, if anyone has any suggestions it'd be greatly appreciated. I have a list of application availability that I'm using to report some stats, ex: PERIOD / APPLICATION / AVAILABILITY % Jan 2013 / Email / 99.52% Feb 2013 / Email / 99.89% I have a table that I'm using to display this information and I have it laid out this way: Application / [Current Month] / [YTD] / [Sparkchart showing trend] Because I want to show the trend I don't implement the parameter filter on the tablix as I need to access all of the months. So in order to get the current month to work, I do a lookup based on the parameter to bring in the right value. However, I don't know how to bring in the average of all of the months for the YTD value. For the latest month if I use =avg(Availability) it is correct, but I somehow need to put in some logic that only brings in the values up to the month that was selected. Any thoughts? Thanks in advance, Sheep
ssrs-2008lookups
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.