Forum Discussion
Solved
Finding the first & last entry for each category in a large dataset
Hello, I am working on a project where I have hundreds of tables with tens of thousands of entries. In each table, I have categories for multiple items and entry dates for each. For example, ...
Insert a pivot table.
"Fruit" in rows area.
"Date" twice in values area. Change the aggregation to Min and to Max.
Insert a pivot table.
"Fruit" in rows area.
"Date" twice in values area. Change the aggregation to Min and to Max.
Detlef_Lewin
Oh my God it works. I didn't know you can put "Date" twice in values area. What a relief. Thank you so much!
Oh my God it works. I didn't know you can put "Date" twice in values area. What a relief. Thank you so much!