Can please anyone help me, as I am working on the telerik pivot grid and while binding I have a datafield named 'date', so I have assign that field in the PivotGridColumnField
on telerik, but I want a PivotGridReportFilterField
for date and it should be of month, day etc. But I am not able to set group interval to the PivotGridReportFilterField.
Please help me out how to assign the quarter, month etc. Do I have to calculate
the data by month, quarter in the database?