1 Reply Latest reply: Oct 23, 2011 5:47 AM by Sajeevan Govindan RSS

    how to use aggr functinon to build a trend chart?

      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?

       

      I attached the samples of the data source.

       

      Thanks for everyones help.