Need help on set analysis

[#1]

Hi All,

I want to show  a chart in which the dimension is the Department and my expressios would be

1.count[cost center id] --(for current month)

2.count([Cost Centre Id] --- (for previous Month]..

Here how can i capture the previous month value?? The user selcts the year and Month..

Can some one plz help me with the expression for previous month....

[v_iyyappan]

Hi,

Use the below expression in  Previous Month

=Count({<Year=,

           Month=,

          Datefield={'>=$(=(Num(Monthstart(AddMonths((Datefield),-1)))))<=$(=(Num(AddMonths((Datefield),-1))))'}>}

          cost center Id)

Regards,

Iyyappan

[#3]

Hi,

Let suppose I have  one dimension (Super Department).. and my first expression is count(distinct cost center id] and how should I write my second expression so that it shows me the count(distinct [Cost Center Id]) for previous month..

[#4]

Hi ,

Will this work if we dont have any selection on the date field?? Sorry this is not working...

[Jason_Michaelides]

I think you'd better post your app so we can see more about what you need.