Share from Total Product's Category Sales

[Anonymous]

Hello everyone,

I am trying to resolve this task: "Add an expression to the chart which will calculate the share of the Sales per Year, Month and Product of the total sales of the product’s ProductCategory. Format the result in %."

I have tried anything but I can't resolve it. Please help!

P.S The dimensions in my report are Year,Month,Product_Category_Name,Product_Name

[petter]

I think this expression should work for you:

Num( Sum(Sales) / Sum(TOTAL <Year,Month,Product_Category> Sales) , '0.0%')

[poojashribanger]

you can use num(expn,'##.00')&'%'