I need your help with the following topic. I have an excel table with the columns below:
project / status / date
For each project it is possible to change the status more then once a month. At the end of each month I want to know the latest project status of the month. (E.g. at the 01.02 project status was 'nok' but it changed on 20.02 to 'ok') If I use the count function in the table chart I can see both project status in February. Instead I only want to see the 'ok' status.