topic Re: Aggregating averages (urgent) in QlikView https://community.qlik.com/t5/QlikView/Aggregating-averages-urgent/m-p/430832#M488556 <HTML><HEAD></HEAD><BODY><P>This seems to be a duplicate of your previous thread. Please try to avoid duplicating threads, since it makes it hard to follow a discussion.</P><P></P><P>Have you checked my answer on the other thread?</P></BODY></HTML> Thu, 17 Jan 2013 14:20:29 GMT swuehl 2013-01-17T14:20:29Z Aggregating averages (urgent) https://community.qlik.com/t5/QlikView/Aggregating-averages-urgent/m-p/430831#M488555 <HTML><HEAD></HEAD><BODY><P>Well I managed to mark my question as Assumed Answered by mistake and now I can't undo it. so here's a repeat to draw it to your attention.</P><P></P><P>Hello folks</P><P></P><P>I am really stuck on this and was due to release the report today! so really hoping you can help.</P><P></P><P>The attached shows an average score for students, against a heirarchy of dimensions: student number, programme, department, faculty. Each student has only one score. Each student is studying 2 programmes: BI and one other.</P><P></P><P>I am trying to avoid double-counting the students at Faculty level while showing an accurate figure at programme and student level. see attached for 2 failed versions.</P><P></P><P>Thanks in advance</P><P></P><P>George</P></BODY></HTML> Thu, 17 Jan 2013 14:17:25 GMT https://community.qlik.com/t5/QlikView/Aggregating-averages-urgent/m-p/430831#M488555 georgina_spary 2013-01-17T14:17:25Z Re: Aggregating averages (urgent) https://community.qlik.com/t5/QlikView/Aggregating-averages-urgent/m-p/430832#M488556 <HTML><HEAD></HEAD><BODY><P>This seems to be a duplicate of your previous thread. Please try to avoid duplicating threads, since it makes it hard to follow a discussion.</P><P></P><P>Have you checked my answer on the other thread?</P></BODY></HTML> Thu, 17 Jan 2013 14:20:29 GMT https://community.qlik.com/t5/QlikView/Aggregating-averages-urgent/m-p/430832#M488556 swuehl 2013-01-17T14:20:29Z