topic Re: Table with 2 Dimension - needing one in QlikView https://community.qlik.com/t5/QlikView/Table-with-2-Dimension-needing-one/m-p/54965#M787661 <HTML><HEAD></HEAD><BODY><P>Both work perfectly.</P><P></P><P>I'm most grateful for the time and effort spent.</P><P></P><P>This is Solved.</P><P></P><P>Thanks,</P><P></P><P>Derek</P></BODY></HTML> Tue, 20 Feb 2018 15:09:05 GMT derekledbetter 2018-02-20T15:09:05Z Table with 2 Dimension - needing one https://community.qlik.com/t5/QlikView/Table-with-2-Dimension-needing-one/m-p/54963#M787659 <HTML><HEAD></HEAD><BODY><P>To whom it may concern:</P><P></P><P>I followed the previous thread with one dimension and it did not work for me.&nbsp; Therefore, I'm writing for assistance in this formula.</P><P></P><P><IMG border="0" class="jive-image image-1" height="192" src="https://community.qlik.com/legacyfs/online/193934_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" width="932" /></P><P></P><P>Any assistance is appreciated in advance.</P><P></P><P>Thanks,</P><P></P><P>Derek</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Table-with-2-Dimension-needing-one/m-p/54963#M787659 derekledbetter 2020-11-25T16:16:04Z Re: Table with 2 Dimension - needing one https://community.qlik.com/t5/QlikView/Table-with-2-Dimension-needing-one/m-p/54964#M787660 <HTML><HEAD></HEAD><BODY><P>May be try one of these</P><P></P><P><STRONG>Count(CSN)/Aggr(NODISTINCT Count(CSN), DepartmentName)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Count(CSN)/Count(TOTAL &lt;<STRONG>DepartmentName</STRONG>&gt; CSN)</STRONG></P></BODY></HTML> Tue, 20 Feb 2018 14:52:43 GMT https://community.qlik.com/t5/QlikView/Table-with-2-Dimension-needing-one/m-p/54964#M787660 sunny_talwar 2018-02-20T14:52:43Z Re: Table with 2 Dimension - needing one https://community.qlik.com/t5/QlikView/Table-with-2-Dimension-needing-one/m-p/54965#M787661 <HTML><HEAD></HEAD><BODY><P>Both work perfectly.</P><P></P><P>I'm most grateful for the time and effort spent.</P><P></P><P>This is Solved.</P><P></P><P>Thanks,</P><P></P><P>Derek</P></BODY></HTML> Tue, 20 Feb 2018 15:09:05 GMT https://community.qlik.com/t5/QlikView/Table-with-2-Dimension-needing-one/m-p/54965#M787661 derekledbetter 2018-02-20T15:09:05Z