Reagarding Max(date) and Total communication (YearTD)
I'm unable to use Max(date) on timestamp date column, where i need to pick the max(date) of the user and need to find his (Total YTD) communication.
I have 4 Columns in my report, Date, CustomerName, Communication type.
This interaction will happen on the map, when I click on CustomerName in the map Then i need to show his related data in the table view with ( his Last Max(date) which is a timestamp column, his Name, and his total interaction YTD ) into a single row.
I'm not able to run Max(date) on that date col and not able to calc YTD interactions.