4 Replies Latest reply: Oct 22, 2011 10:42 AM by joezhangyan RSS

    Support on the aggr functions and calculate

      I have a data source link this:

      //Inventory_info:

      Date

      ItemName

      Qty

      Factory

       

       

      //Price: (one ItemName may included several price, so used the average price to calculate)

      ItemName

      Price

       

      I want to creat a trend chart for inventory value in different days, so i used the calculation as:

       

      sum( aggr(sum(Qty),ItemName)*aggr(Price,ItemName)  )

       

      can not achieve this, so how should i work on that? Any ideas?