Forum Discussion
Solved
Summarize column without removing blanks
I have a table with two columns, for the sake of the example they'll be called Name and Date
Below is a sample of that table
| Name | Date |
| a | 1/1/2024 |
| a | 2/1/2024 |
| a | 3/1/2024 |
| b | 5/4/2024 |
| b | 5/5/2024 |
| c | |
| d | |
| e | |
| f | 6/6/2024 |
| f | 6/7/2024 |
I want to show only the Latest Date by Summarizing the column
But at the same time I don't want to hide the blank rows so my final table should look like this
| Name | Date |
| a | 3/1/2024 |
| b | 5/5/2024 |
| c | |
| d | |
| e | |
| f | 6/7/2024 |
Any suggestions on how to achieve that will be appricated.
Thank you.
Hello samerhajjar ,
you add it to a table or matrix and you click on the drop down on the name field and check the show items with no data and the blanks will show.
1 Reply
Hello samerhajjar ,
you add it to a table or matrix and you click on the drop down on the name field and check the show items with no data and the blanks will show.