<?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 How to create different level Totals in Pivot Table? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-create-different-level-Totals-in-Pivot-Table/m-p/393771#M146823</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Calibri&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: &amp;amp;quot;Times New Roman&amp;amp;quot;; mso-bidi-theme-font: minor-bidi;"&gt;Qlikview: 9 SR7&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;Qlikview - Pivot Table I have requirement of revenue analysis for sales rep where I show&lt;BR /&gt;in this order sales rep, company, department, sales&lt;BR /&gt;&lt;BR /&gt;team, account and 3 streams of revenue a, b, c for account I am showing a, b, c&lt;BR /&gt;as dimensions and giving totals by it I have expressions for all three revenue streams&lt;BR /&gt;by months current, prior and variance which are 36 expressions, &lt;/SPAN&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;and&lt;BR /&gt;I will need to give totals at the first dimension sales rep for all three&lt;BR /&gt;streams of revenue as well for all expressions.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;I am not sure how to approach as at this time I am able to give&lt;BR /&gt;only rep total revenue whereas I am required to show 3 streams of revenue&lt;BR /&gt;totals and a total of three streams for the sales rep.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;Any ideas on how I could approach this is appreciated.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thnaks for your time, Pad&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 01 Feb 2013 14:06:08 GMT</pubDate>
    <dc:creator />
    <dc:date>2013-02-01T14:06:08Z</dc:date>
    <item>
      <title>How to create different level Totals in Pivot Table?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-create-different-level-Totals-in-Pivot-Table/m-p/393771#M146823</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Calibri&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: &amp;amp;quot;Times New Roman&amp;amp;quot;; mso-bidi-theme-font: minor-bidi;"&gt;Qlikview: 9 SR7&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;Qlikview - Pivot Table I have requirement of revenue analysis for sales rep where I show&lt;BR /&gt;in this order sales rep, company, department, sales&lt;BR /&gt;&lt;BR /&gt;team, account and 3 streams of revenue a, b, c for account I am showing a, b, c&lt;BR /&gt;as dimensions and giving totals by it I have expressions for all three revenue streams&lt;BR /&gt;by months current, prior and variance which are 36 expressions, &lt;/SPAN&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;and&lt;BR /&gt;I will need to give totals at the first dimension sales rep for all three&lt;BR /&gt;streams of revenue as well for all expressions.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;I am not sure how to approach as at this time I am able to give&lt;BR /&gt;only rep total revenue whereas I am required to show 3 streams of revenue&lt;BR /&gt;totals and a total of three streams for the sales rep.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: &amp;amp;quot;Arial&amp;amp;quot;,&amp;amp;quot;sans-serif&amp;amp;quot;; font-size: 10pt;"&gt;Any ideas on how I could approach this is appreciated.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thnaks for your time, Pad&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 01 Feb 2013 14:06:08 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-create-different-level-Totals-in-Pivot-Table/m-p/393771#M146823</guid>
      <dc:creator />
      <dc:date>2013-02-01T14:06:08Z</dc:date>
    </item>
  </channel>
</rss>

