Summarize '%' issue

[MC Paris]

Hi everybody,

Report studio 10.2.1

I had some issue with the summarize in %.

List: country - product - sales measure - % Y vs Y-1
Filters: the user can choose the country(ies) and the product(s) via a container filter.
So the list is updating by the choice of the user.

I use "Summarize in Output" and the "sales measure" total  is ok but not the "% Y vs Y-1" total, it makes the sum of "% Y vs Y-1".  :'(

Thank you for you help.

[JBCLARK20]

HI MC Paris,

I encountered a similar issue and found the Aggregate function to be useful in calculating percentages.
In a query create a  data item:  aggregate ([data item1]) / aggregate ([data item2])
On the report, set the data format to percent.

[MC Paris]

Hi JB,

thx for your trick, I will try it and tell you if it's ok.

[chalapati4u]

Hi

I also have similar issue, Did any find the solution.
Please share me.

thanks,
chala