Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think this expression should work for you:
Num( Sum(Sales) / Sum(TOTAL <Year,Month,Product_Category> Sales) , '0.0%')
you can use num(expn,'##.00')&'%'