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.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  YTD up to this month HELP

Author  Topic  elynkml Starting Member 1 Post Posted - 2010-08-18 : 01:53:46 Revenue Jan Feb March April May June July Aug Sept Oct Nov Dec Total YTD PY 123 111 145 352 223 321 107 283 351 232 324 234 2806 1665 CY 107 283 351 123 111 145 234 111 1465 Dimension - PY (Previous Year) and CY (Current Year) as row By column is month Total is showing total from Jan - Dec YTD must be total up to current month for both PY and CY How can I formula the YTD in SSAS?