That I'm using in a pivot table where the filter context of Query1[iq] doesn't exist because it does not appear in the pivot table, instead, the filter context contains fields that are irrelevant to this equation. I'm just using it because what I want, on a row by row basis, is to just sum the value when query1[dq] = query1[iq]. Can I just use this function(which I made for a different pivot table) in this table? Or put another way, what is the context of the Query1[iq] when the filter context is nothing, is it the whole table?
I suspect it may be the latter. If it is, do I need to do a sumx to sum all rows where Query1[iq] = Query1[dq]? It's awfully tempting to just do sum(if(query1[iq]=query1[dq],amt,0)) like we would in sql or excel before sumif functions, but again, this is not a normal language.