Prev: converting character datetime(ISO) to numeric datetime20.
Next: PROC SQL: Concatenating values of several columns into several macro variables
From: Carrie Wilmoth on 24 Mar 2010 11:22
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
 | 
Pages: 1
Prev: converting character datetime(ISO) to numeric datetime20.
Next: PROC SQL: Concatenating values of several columns into several macro variables