Hi

I am trying to sum values cumulatively in a cube using the PeriodsToDate function. The function below works well when applying to all fact table records. However, each record in the fact table is classified as one of three types. I would actually like the sum function to add only the facts pertaining to two of the three types

I have tried Filter() and other combinations. The closest I can get is hard-coding one of the two status member names into the second half of the PeriodsToDate formula, but then I'm missing the other one... I know the answer is a simple one but I just can't crack it

Any and all assistance appreciated
Cheers
Nic

sum
PeriodstoDate([Transaction Date].[(All)], [Transaction Date].CurrentMember)
([Account Category].CurrentMember,[Measures].[Amount]
)

Assuming that [Account Category] is the type dimension:

Sum(PeriodstoDate([Transaction Date].[(All)],
[Transaction Date].CurrentMember),
([Account Category].CurrentMember,[Measures].[Amount])))
- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

That's exactly what I was missing. Thanks Deepak, much appreciated!