Need help ???

[veeranj]

Hi Group,

I have table like position_id and its creation_date and its closed date and status(closed or open)

Now i want to calculate based on months how many positions are opened and how many positions are closed.

As here i am having two dates,can i have a common(single) date and based on that dimension,i want to find no.of posiitons opened and closed.??

Thanks,

Anjee

[sujeetsingh]

How to use a common date.

One option i can suggest is that you can use Min(Creation_Date) and Max(Closed_Date) and create a master calender.

[mangalsk]

Hello,

You can do it using concept of master calender

[jagan]

Hi,

Attach some smaple data and file.

Regards,

jagan.

[MarcoWedel]

you can crosstable load the table to get the date and event type (opened / closed) as two different fields.

Selecting in a month(date)-Listbox would select both kinds of events (better create a seperate month field during load)

You could create two expressions like

count({$<event_type={'opened'}>} date)

and

count({$<event_type={'closed'}>} date)

to count the opened and closed positions per dimension value (e.g. month).

hope this helps

regards

Marco