Forum Discussion
Add an index column where repeat dates have the same index number
Hello,
I am trying to add an index column. I need repeating dates to have the same index number. Any ideas?
You can highlight your Date column, hit the Group By button on the ribbon, and choose "All Rows" for the aggregation. While it's aggregated, add an Index column. Then expand the nested tables (uncheck the Date column from the Expand option, as you will already have it).
Regards,
Pat
1 Reply
You can highlight your Date column, hit the Group By button on the ribbon, and choose "All Rows" for the aggregation. While it's aggregated, add an Index column. Then expand the nested tables (uncheck the Date column from the Expand option, as you will already have it).
Regards,
Pat