topic Pivot Hierarchy Subtotal in QlikView https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288394#M1200940 <HTML><HEAD></HEAD><BODY><P>So you can't open it? You might be able to use one of your Recovery attempts to open the file. I think you are allowed to "recover" 3 or 4 files with Personal Edition. Otherwise, yeah...you need a license.</P><P>Regards,</P></BODY></HTML> Tue, 16 Nov 2010 21:06:50 GMT vgutkovsky 2010-11-16T21:06:50Z Pivot Hierarchy Subtotal https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288391#M1200937 <HTML><HEAD></HEAD><BODY><P>I am trying to do a subtotal in a Hierarchy for a pivot.</P><P></P><P>There are three steps attached is a sample in excel</P><P></P><P>Total income has 6 children (and subtotal)</P><P>other income total has 2 children( and subtotal)</P><P>Total revenues has total income and other income total as its children( grand total)</P><P></P><P>how would you set this up in QV?</P></BODY></HTML> Mon, 15 Nov 2010 22:36:38 GMT https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288391#M1200937 2010-11-15T22:36:38Z Pivot Hierarchy Subtotal https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288392#M1200938 <HTML><HEAD></HEAD><BODY><P>See attached solution.</P><P>Regards,</P></BODY></HTML> Mon, 15 Nov 2010 23:39:38 GMT https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288392#M1200938 vgutkovsky 2010-11-15T23:39:38Z Pivot Hierarchy Subtotal https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288393#M1200939 <HTML><HEAD></HEAD><BODY><P>Vlad,</P><P></P><P></P><P>I am sure this works fine but unfortunately I have the personal edition. I am in the process of building a POC in hopes to get our company to purchase QV.</P><P></P><P></P></BODY></HTML> Tue, 16 Nov 2010 14:58:45 GMT https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288393#M1200939 2010-11-16T14:58:45Z Pivot Hierarchy Subtotal https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288394#M1200940 <HTML><HEAD></HEAD><BODY><P>So you can't open it? You might be able to use one of your Recovery attempts to open the file. I think you are allowed to "recover" 3 or 4 files with Personal Edition. Otherwise, yeah...you need a license.</P><P>Regards,</P></BODY></HTML> Tue, 16 Nov 2010 21:06:50 GMT https://community.qlik.com/t5/QlikView/Pivot-Hierarchy-Subtotal/m-p/288394#M1200940 vgutkovsky 2010-11-16T21:06:50Z