I am struck in one place. I have a new requirement to calculate YTD Average of some data for which I am attaching sample file.
In my sample file P&B Qty or Actual Qty have figures where Particulars is Metal.
Another line Item with the name of Alumina have other data such as effeciency, issue prices of both P&B and Actual.
I have given there my desired output which is calculated through EXCEL's very popular SUMPRODUCT formula. That desired output I want in my Sample Qlikview Document, which also I am attaching herewith.
I have made a simple Pivot chart for the same. Can any one please help how to achieve the results which can be easily done by SUMPRODUCT formula, but I have not found anything similar to that in Qlikview.
I hope I have been clear in explaining my problem and what I actually want.