topic Re: How to only show the partial sum of expression in a pivot ignoring/hiding the dimension level sums in QlikView https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072739#M932818 <HTML><HEAD></HEAD><BODY><P>A sample will be easier to help you out. Are you able to provide one?</P></BODY></HTML> Tue, 08 Mar 2016 18:41:52 GMT sunny_talwar 2016-03-08T18:41:52Z How to only show the partial sum of expression in a pivot ignoring/hiding the dimension level sums https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072736#M932815 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot table with 5 dimensions, I'm calculating an expression (here MGL) and all I wanted to show is its total ignoring the session level values.Is this possible in qlikview? I've inserted the screenshot below here. Many thanks in advance.</P><P></P><P></P><P><IMG alt="qv_query.png" class="jive-image image-1" height="119" src="https://community.qlik.com/legacyfs/online/116633_qv_query.png" style="height: 119.497px; width: 756px;" width="756" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072736#M932815 2020-11-25T16:16:04Z Re: How to only show the partial sum of expression in a pivot ignoring/hiding the dimension level sums https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072737#M932816 <HTML><HEAD></HEAD><BODY><P>You can use Dimensionalilty to show an output wherever you desire. Check out these links</P><P><A href="https://community.qlik.com/docs/DOC-7969">How to use - Dimensionality()</A></P><P><A href="https://community.qlik.com/docs/DOC-8006">The second dimension... or how to use secondarydimensionality()</A></P></BODY></HTML> Wed, 02 Mar 2016 15:30:17 GMT https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072737#M932816 sunny_talwar 2016-03-02T15:30:17Z Re: How to only show the partial sum of expression in a pivot ignoring/hiding the dimension level sums https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072738#M932817 <HTML><HEAD></HEAD><BODY><P>Thanks for this article, but still doesn't solve of my problem. More context on how to use dimensionality will be great here.</P></BODY></HTML> Tue, 08 Mar 2016 16:04:08 GMT https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072738#M932817 2016-03-08T16:04:08Z Re: How to only show the partial sum of expression in a pivot ignoring/hiding the dimension level sums https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072739#M932818 <HTML><HEAD></HEAD><BODY><P>A sample will be easier to help you out. Are you able to provide one?</P></BODY></HTML> Tue, 08 Mar 2016 18:41:52 GMT https://community.qlik.com/t5/QlikView/How-to-only-show-the-partial-sum-of-expression-in-a-pivot/m-p/1072739#M932818 sunny_talwar 2016-03-08T18:41:52Z