topic Subtotal inTable/Pivot in QlikView https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273323#M102281 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to calculate the subtotal for 1 specific variable sum(€) in table/or pivot.</P><P>In my example i want to do a report with bank and user and i need to calculate the subtotal for each bank.</P><P>I've found in the options the subtotal flag but qlik return the total off all data.</P><P></P><P>i add the example so it's easy to understand.</P><P></P><P>Can you help me?</P><P></P><P>Thank you</P><P></P><P>marco</P></BODY></HTML> Wed, 08 Jun 2011 12:53:18 GMT 2011-06-08T12:53:18Z Subtotal inTable/Pivot https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273323#M102281 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to calculate the subtotal for 1 specific variable sum(€) in table/or pivot.</P><P>In my example i want to do a report with bank and user and i need to calculate the subtotal for each bank.</P><P>I've found in the options the subtotal flag but qlik return the total off all data.</P><P></P><P>i add the example so it's easy to understand.</P><P></P><P>Can you help me?</P><P></P><P>Thank you</P><P></P><P>marco</P></BODY></HTML> Wed, 08 Jun 2011 12:53:18 GMT https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273323#M102281 2011-06-08T12:53:18Z Subtotal inTable/Pivot https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273324#M102282 <HTML><HEAD></HEAD><BODY><P>Hello Marco,</P><P></P><P>Go to the chart properties, General tab and change the chart type to "Pivot Table". Then go to the Presentation tab, click on "User" dimension under "Dimensions and Expressions" and check "Show Partial Sums". Finally check "Always fully expanded".</P><P></P><P>Is that what you are expecting?</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/people/mabaeyens" style="font-size: 12px; outline-style: none; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #007fc0; zoom: 1; background-position: no-repeat no-repeat;">Miguel Angel Baeyens</A></P><P>BI Consultant</P><P><A class="jive-link-external-small" href="http://www.grupocomex.com/" style="font-size: 12px; outline-style: none; color: #007fc0;">Comex Grupo Ibérica</A></P></BODY></HTML> Wed, 08 Jun 2011 13:02:34 GMT https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273324#M102282 Miguel_Angel_Baeyens 2011-06-08T13:02:34Z Subtotal inTable/Pivot https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273325#M102283 <HTML><HEAD></HEAD><BODY><P>Great! </P><P></P><P>Thank you Miguel!</P></BODY></HTML> Wed, 08 Jun 2011 13:10:40 GMT https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273325#M102283 2011-06-08T13:10:40Z Re: Subtotal inTable/Pivot https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273326#M102284 <HTML><HEAD></HEAD><BODY><P>Great! </P><P></P><P>Thank you Miguel!</P></BODY></HTML> Wed, 08 Jun 2011 13:46:48 GMT https://community.qlik.com/t5/QlikView/Subtotal-inTable-Pivot/m-p/273326#M102284 2011-06-08T13:46:48Z