I have a data source link this:
//Price: (one ItemName may included several price, so used the average price to calculate)
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.