title: query of calculate the annual profit growth in qlikview by using text object
body: <p>I want to calculate the annual average profit growth rate for 5 years by using a text object.  Qlikview does not seem to support nested aggregation... I am new to QlikView, can anyone can help me?</p>
  
  <pre><code>Tried query:
  
  ='Annual Growth Rate  (2003-2007)  :' &amp; avg((sum(Profit_per_Product)/sum(Total_Retail_Price))*100)
  </code></pre>
  
  <p>Thanks in advance!</p>