Forum Discussion
Data Table help
Hi,
If there is only 1 date which falls at the intersection of the row and column header, then the aggregation function (such as max or min) will not make a difference. If there are multiple dates, then what result do you want to show - all in the same cell with a comma seperator? You may use the CONCATENATEX() function. To receive further help, share some data to work with and show the expected result.
Hi,
If there is only 1 date which falls at the intersection of the row and column header, then the aggregation function (such as max or min) will not make a difference. If there are multiple dates, then what result do you want to show - all in the same cell with a comma seperator? You may use the CONCATENATEX() function. To receive further help, share some data to work with and show the expected result.
actually that makes perfect sense, im looking through my dates right now and your correct, even with the aggregation it wont make a difference since im only trying to display one single date per item