topic COUNT(TOTAL Field) In Pivot in QlikView https://community.qlik.com/t5/QlikView/COUNT-TOTAL-Field-In-Pivot/m-p/221960#M74709 <HTML><HEAD></HEAD><BODY><P>Hi Amien,</P><P>see the screen shot:</P><P>Good luck!</P><P>Rainer</P><P></P><P></P></BODY></HTML> Thu, 22 Oct 2009 14:43:52 GMT 2009-10-22T14:43:52Z COUNT(TOTAL Field) In Pivot https://community.qlik.com/t5/QlikView/COUNT-TOTAL-Field-In-Pivot/m-p/221959#M74708 <HTML><HEAD></HEAD><BODY><P>I'm using COUNT(TOTAL Field) in an expression. I have a dimension that has 2 records.. so it looks something like this:</P><P></P><P>dim exp total exp</P><P>subject1 10 56</P><P>------------ 20 56</P><P>subject2 12 56</P><P>------------ 14 56</P><P></P><P>what i want is this:</P><P>dim exp total exp</P><P>subject1 10 30</P><P>------------ 20 30</P><P>subject2 12 26</P><P>------------ 14 26</P><P></P><P>so i want the count of total of that dimension and not an overall</P><P>Thanks in advanced</P><P></P></BODY></HTML> Thu, 22 Oct 2009 13:26:26 GMT https://community.qlik.com/t5/QlikView/COUNT-TOTAL-Field-In-Pivot/m-p/221959#M74708 amien 2009-10-22T13:26:26Z COUNT(TOTAL Field) In Pivot https://community.qlik.com/t5/QlikView/COUNT-TOTAL-Field-In-Pivot/m-p/221960#M74709 <HTML><HEAD></HEAD><BODY><P>Hi Amien,</P><P>see the screen shot:</P><P>Good luck!</P><P>Rainer</P><P></P><P></P></BODY></HTML> Thu, 22 Oct 2009 14:43:52 GMT https://community.qlik.com/t5/QlikView/COUNT-TOTAL-Field-In-Pivot/m-p/221960#M74709 2009-10-22T14:43:52Z COUNT(TOTAL Field) In Pivot https://community.qlik.com/t5/QlikView/COUNT-TOTAL-Field-In-Pivot/m-p/221961#M74710 <HTML><HEAD></HEAD><BODY><P>perfect. . Thanks!</P></BODY></HTML> Thu, 22 Oct 2009 15:03:15 GMT https://community.qlik.com/t5/QlikView/COUNT-TOTAL-Field-In-Pivot/m-p/221961#M74710 amien 2009-10-22T15:03:15Z