This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a project data and I am calculating the number of projects reaching a certain gate in a certain month. I would like to limit the data that if date is the maximum and value is the maximum per project then display max date and max value per project only once. So the rest of the fields after latest date with first max value would be removed or replaced with null. In the example, Project one would have only data until 201901 and 201902 would be removed because it is the latest date with first max value per project. How could I do it?
I was looking for a way how to limit number of rows when a project has the max value in Value column and have the latest date. In my example, I have Project 1 and two rows: 201901 Value 12 and 201902 Value 12. So I wanted to display only 201901 Value 12 and remove the dates after 201901 with max value (in this case, 201902 Value 12)
Multi-row formula presented in below solution helped to achieve result.