I have an object in the Universe that is defined to “average” when aggregated. For one specific report, however, I need to sum this object. How do I change the aggregate function just for this report ? I tried the Data Manager but the “aggregate function” is greyed out.
The object is what it is. You cannot change the definition of the object (dimension, detail, measure, projection function, data type) in the report. You could have the universe developer set up two different objects, each with its own projection function… that’s the only thing I can think of.
I think Dwayne’s suggestion is worth testing, but I suspect that there might end up being a conflict between the standard projection for the measure and the reporter function… :?