Hi,
I have a Period Dimension (Year,Quarter,Month)

I have a Calculated Member called CustNo
DistinctCount({[Customers].[No].Membres]})

I need to add a new Calculated Member that provide:

I need the difference of CustNo between [Year] and [PreviousYear]


How I can obtain this?

Here is a calculated measure to find this difference:

'iif(Ancestor([Period].CurrentMember,[Period].[Year])
is [Period].[Year].Members.Item(0), NULL,
[Measures].[CustNo] -
([Measures].[CustNo],ParallelPeriod([Period].[Year])))'

- Deepak

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

Thank you very nuch!

Dario

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> ha scritto nel messaggio
news:uth$zg20EHA.1264 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Here is a calculated measure to find this difference:

'iif(Ancestor([Period].CurrentMember,[Period].[Year])
is [Period].[Year].Members.Item(0), NULL,
[Measures].[CustNo] -
([Measures].[CustNo],ParallelPeriod([Period].[Year])))'

- Deepak

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