Hello!

I have a chart in an Active Report that can be filtered by two categories:

The problem is: when I run my active report (if no filter is applied) I get the following result

That happens because the aggregation method in my visualization is a Total (so the query SUM all the percentages) that should be go from 0% to 100% (and not to 5000% as in the image above)

I was searching for a way to use "Calculate" as a method to aggregate my results instead the Total, I think that it can fix the problem.
I also tried to use the "Average", but testing the aggregations on the output Query it didn't return the same result.

Do you have any suggestions?

Thank you all!

------------------------------
Thélio Freitas
------------------------------

#CognosAnalyticswithWatson