I am trying to have a date aggregate in the grid and use the Max date as the aggregate. I keep getting an error in the PivotGrid and my SQL output is just a standard date field. Is this possible to achieve?
Thanks.
Thanks.
<telerik:PivotGridAggregateField DataField="MyDate" Aggregate="Max" Caption="Mydate" />