Forum Discussion
Help with SQL statement to pivot field values into column headers
Hello all, I've managed to filter all the data I need but I'm struggling to pivot the [Milestones].[Name] column into headers (there are 25 unique values in this field). Syntax so far which w...
I've found a solution for part of the problem which will pivot the Milestones into column headers. But I'm having the same issue with the aggregate function.
How do I display the DateTime instead of counting the entries?