Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jj22171
Starting Member
3 Posts |
 Posted - 2012-09-06 : 17:49:14
|
| I have a chart with calculated series using moving average of 3 months of data and be able to display the last 6 months period. For a correct moving average for month 1, I need to bring in the data for 2 months prior but I don't want these 2 months displayed in the chart. I tried using the visibility option (based on a condition) but it hides the entire series if the condition is true. Is there another way of hiding the 2 months data?Thanks for your help |
|
|
jj22171
Starting Member
3 Posts |
Posted - 2012-09-10 : 14:17:31
|
| Anyone has idea/thought to, at least, point me to a solution? Would greatly appreciate it. |
 |
|
|
|
|
|
SSRS Moving average