http://www.endusersharepoint.com/STP/ SharePoint QA en Thu, 21 May 2009 10:39:33 +0000 http://www.endusersharepoint.com/STP/topic/need-help-with-solution#post-6716 Fri, 15 May 2009 13:29:15 +0000 srsluvselvis 6716@http://www.endusersharepoint.com/STP/ <p>I have a list with the below sample data/columns: entry date, location, numeric points field for survey ratings (A=1, B=2, C=3, D=4 and F=5). I have a view grouped by location which won't then let me group by date, but I have sorted on date. I want to add a listview webpart to my report page so managers can select the location of choice and get a small chart displaying the average rating of the points by date by location.<br /> I can't figure out how to sum a calculated column and then average it by the 4 questions per date the survey results will show. Please help!<br /> Survey Focus Area Jan Feb Mar Apr<br /> Responsiveness 1.97 1.75 1.71 </p> <p>Solutions Focused 1.97 1.92 2.00 </p> <p>Resource Availability 1.97 1.67 1.88 </p> <p>Professionalism 1.65 1.58 1.50 </p>