title: Use pivot table to represent array of object data
body: <p>I'm trying to use pivot table to represent the following data,</p>
  
  <pre><code>$.pivotUtilities.tipsData=[
                {status:"open",year:2014,value:100.00},
                {status:"open",year:2015,value:200.00},
                {status:"open",year:2016,value:300.00},
                {status:"approved",year:2016,value:10.00},
                {status:"approved",year:2015,value:20.00},
                {status:"approved",year:2014,value:30.00},
                {status:"closed",year:2016,value:3.00},
                {status:"closed",year:2014,value:3.00},
                {status:"closed",year:2013,value:-10.00}
                ]   
  
      var utils = $.pivotUtilities;
  
      $("#output").pivot(
        utils.tipsData, {
          rows: ["status"],
          cols: ["year"],
          vals: ["value"]
        });
  </code></pre>
  
  <p>I get the following result</p>
  
  <p><a href="https://i.stack.imgur.com/SWYm2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SWYm2.png" alt="enter image description here"></a></p>
  
  <p>but I need to represent the value not number of values for each status,like this image
  <a href="https://i.stack.imgur.com/WvbFr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WvbFr.png" alt="enter image description here"></a></p>
  
  <p>Can anyone help me to do that?</p>