Year to date calculation in OLAP cube

  • Follow


I have fiscal year and fiscal month as dimensions in my OLAP cube as
well as revenue as a measure.  I would like to have a rolling total by
fiscal year that calculates the year to date revenue.  This is my
current attempt (which does not work):
Sum(YTD([Years].[FY]),[MEASURES].[Sum Revenue]),
FORMAT_STRING="DOLLAR15."

Any suggestions?
Thanks!
Carrie
0
Reply cawilmoth (1) 3/24/2010 3:22:29 PM


0 Replies
594 Views

(page loaded in 0.021 seconds)

Similiar Articles:













7/24/2012 9:12:48 PM


Reply: