This is a sample i obtained. http://community.qlik.com/members/msadrikhcb/files/totals-problem.qvw.aspx
I only need the total of functions of process 1 and the the grand total.
also, choosing a process from the listbox changes the grand total and thus the Agg.
I have managed to partially sort out the partial sum problem by using dimensionality().
Dimensionality() returns the "level" of the cell in a pivot. Dimensionality() = 0 would be your grand total, the partial sum on the first dimension. Each subsequent level would be higher.
if(Dimensionality()>0, Current Expression)
That way, for your grand total, those lines will be null. They appear as a dash by default, but you can change that on the presentation tab.In another post I came across the NoDistinct fucntion, which can apparently solve the changing sums issue when something is selected from a listbox. I am reading in qlikview help now and will try to perform this.Hope this helps.