title: How to customize partial sum in QlikView Pivot table
body: <p>I'm a beginner for QlikView. I learnt that by going to presentation tab and click on show partial sum box and subtotal box, I can get the partial sum and subtotal. But my task is to calculate the average which means (subtotal/no of record)/ (partial sum/no of record). I've been suggested to use set analysis to calculate too. I have somehow calculated the numerator part but unable to get denominator.</p>
  
  <p>This is my numerator :</p>
  
  <pre><code>Let vNumerator = 'SUM({&lt;ACTIVITY={num1,num2}&gt;} BOX_COUNT)/Count (record1 &amp; record2)';
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/tHnkA.png" alt="Pivot table">
  <img src="https://i.stack.imgur.com/FBol2.png" alt="Presentation tab"></p>
  
  <p>Any help is much appreciated.</p>