I have a file with field "Category" (categories are Recieved, Started, Pause, Restarted and Ended) and a date field "Date". I want to calculate the number of months of activity (between Started-Paused and Restarted-Ended), and not the periods with inactivity (Pause-Restarted).
Anyone have a solution? Ive tried many things, but not solved it.