I am not sure that I understand correctly what your goal is. The data you presented is like for RadGrid, but you have written this post in the RadPivotGrid forum. What control do you want to use?
If you want to use the RadGrid control, you could achieve your goal by using the Grouping functionality of RadGrid. Then you could group by UserName and then by Name. You could check this
online demo application for more information on this approach.
If you want to use RadPivotGrid you should modify your datasource to have PivotData
. Then you could set three column fields with DataField equal to UserName, Name, and Date.
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed