How to Graph SumProduct of Columns

[lain_]

I have a pivot table in the qvw file linked below. Is there anyway to do the sumproduct I show in the excel file? I copied the pivot table from qvw file to the excel sheet. What I want is the table to the right in the excel sheet but in QlikView and to eventually put this in a graph (the table isn't as important, what needs to be shown is the graph, the table is an intermediate step to get to the graph). Is there anyway to do this in QlikView?

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr((Sum({$<b = {0.25, 0.5, 0.75, 1}>} val) / Sum({$<b={0.25, 0.5, 0.75, 1}>} total <month, a> val)) * Only({$<b={0.25, 0.5, 0.75, 1}>} b), a, b, month))

[lain_]

Thank you!