Capturing open orders that occured in a certain period in time

Hi Guys,

I have a requirement where they client needs to see the orders that where open in a certain point in time. For example, an order that was open in july would not be open in september, but how do i show that order, and total orders that where open in july (or any other previous month before they were closed)? Currently we just calculate the total open orders at the end of each month and input it  in excel manually month-by-month and build a line chart of the trend. IS there a way to do this with spotfire?

Thanks in advance

(2) Answers