i'm develeping a qv extension where i need to iterate on the data rows and show that data on a drag&drop pivot table. the problem is that sometimes i want to aggregate sum of the dimentions that was picked for the object (and not all of them). my question is, is it possible to use qv aggregation functions on some of the dimentions in the data in ths script.js?
e.g if i have the dimentions year, month and customer and the expression Avg([Invoice Revenue]) in the data but i want to aggregate only year and month for that expression.
thanks in advance