https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1851218#M1215651 <P>I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.</P> <P><A href="https://www.prepaidcardstatus.biz/" target="_self">PrepaidCardStatus</A></P> Tue, 26 Oct 2021 03:37:59 GMT Langosh 2021-10-26T03:37:59Z https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1849238#M1215572 <P>I have a pivot table (see in the picture), I have two problems:</P> <P>1) I don't see the grand total at the bottom of the table, but only on the right divided by each year, and I don't even see the grand total on the right</P> <P>2) I would need to do a set analysis for current month - 12 (month is the one marked in red) and not all months for selected years, but only for current year, current month - 12, my current expression is Sum(CONSUMI_SMC)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlikmonthyear.jpg" style="width: 477px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/64796iB739001DC3483742/image-dimensions/477x61?v=v2" width="477" height="61" role="button" title="qlikmonthyear.jpg" alt="qlikmonthyear.jpg" /></span></P> Wed, 20 Oct 2021 08:00:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1849238#M1215572 danosoft 2021-10-20T08:00:09Z https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1851116#M1215643 <P>Sorry but not solution for that in QlikView??</P> Mon, 25 Oct 2021 06:35:35 GMT https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1851116#M1215643 danosoft 2021-10-25T06:35:35Z https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1851218#M1215651 <P>I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.</P> <P><A href="https://www.prepaidcardstatus.biz/" target="_self">PrepaidCardStatus</A></P> Tue, 26 Oct 2021 03:37:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1851218#M1215651 Langosh 2021-10-26T03:37:59Z https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1852310#M1215706 <P>This is not the solution to my question.... but where i can see your webinar?</P> <P>My questions are:</P> <P>2) I would need to do a set analysis for current month - 12 (month is the one marked in red) and not all months for selected years, but only for current year, current month - 12, my current expression is Sum(CONSUMI_SMC)</P> <P>and</P> <P>1) I don't see the grand total at the bottom of the table, but only on the right divided by each year, and I don't even see the grand total on the right</P> Wed, 27 Oct 2021 08:33:40 GMT https://community.qlik.com/t5/QlikView/Problem-with-general-Total-in-pivot-table-and-other/m-p/1852310#M1215706 danosoft 2021-10-27T08:33:40Z