<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic In Pivot Table display two times &amp;quot;Total&amp;quot; in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/In-Pivot-Table-display-two-times-quot-Total-quot/m-p/40645#M6864</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have prepared one pivot table which contains Four dimensions, and MTD and PYTD expressions and I have do pivoting with one dimension called "Month".&lt;/P&gt;&lt;P&gt;In Presentation tab I have marked "Show Partial Sums" for all dimensions,&lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/199745_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;After than when I look into Pivot Table, it displays Two times Total in Partial sum of Month as like as below.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG border="0" class="jive-image image-1" height="150" src="https://community.qlik.com/legacyfs/online/199741_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" width="961" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Need only One time Total as per below.&lt;/P&gt;&lt;P&gt;&lt;IMG border="0" class="jive-image image-3" height="150" src="https://community.qlik.com/legacyfs/online/199746_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" width="961" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;In Advance.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 16 Apr 2018 12:49:36 GMT</pubDate>
    <dc:creator>infosense_devel</dc:creator>
    <dc:date>2018-04-16T12:49:36Z</dc:date>
    <item>
      <title>In Pivot Table display two times "Total"</title>
      <link>https://community.qlik.com/t5/QlikView/In-Pivot-Table-display-two-times-quot-Total-quot/m-p/40645#M6864</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have prepared one pivot table which contains Four dimensions, and MTD and PYTD expressions and I have do pivoting with one dimension called "Month".&lt;/P&gt;&lt;P&gt;In Presentation tab I have marked "Show Partial Sums" for all dimensions,&lt;/P&gt;&lt;P&gt;&lt;IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/199745_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;After than when I look into Pivot Table, it displays Two times Total in Partial sum of Month as like as below.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG border="0" class="jive-image image-1" height="150" src="https://community.qlik.com/legacyfs/online/199741_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" width="961" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Need only One time Total as per below.&lt;/P&gt;&lt;P&gt;&lt;IMG border="0" class="jive-image image-3" height="150" src="https://community.qlik.com/legacyfs/online/199746_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" width="961" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;In Advance.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 16 Apr 2018 12:49:36 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/In-Pivot-Table-display-two-times-quot-Total-quot/m-p/40645#M6864</guid>
      <dc:creator>infosense_devel</dc:creator>
      <dc:date>2018-04-16T12:49:36Z</dc:date>
    </item>
    <item>
      <title>Re: In Pivot Table display two times "Total"</title>
      <link>https://community.qlik.com/t5/QlikView/In-Pivot-Table-display-two-times-quot-Total-quot/m-p/40646#M6865</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hello&lt;/P&gt;&lt;P&gt;for me, it means that you have 2 different values for salesrep, so 1 total line per each&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 16 Apr 2018 14:30:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/In-Pivot-Table-display-two-times-quot-Total-quot/m-p/40646#M6865</guid>
      <dc:creator>olivierrobin</dc:creator>
      <dc:date>2018-04-16T14:30:49Z</dc:date>
    </item>
  </channel>
</rss>

