This content has been marked as final. Show 6 replies
sum(revenue by product )/sum (revenue by year)*100
Ex: You got metric as "Measures"."#Sales"
Product column as Product."Product"
for metric "Measures"."#Sales"->fx use the below, that would be Sales group by Product.
sum("Measures"."#Sales" by Product."Product")
Mark if helps let me know for issues
Thank you Srini, I will try that, Please help me how to achieve the format which i mentioned. When I am trying to add % The format which I am getting is below,
Employee Name 2007 2008 2009 2010 2011 2012 YTD % total flows
But I need to get the % below.
Since you are getting % values using (product revenue for year)/(revenue for year)*100 I would suggest to get % symbol using Column Properties->Data Format->Override Default Data Format
If helps mark :)
I am getting % as a column, but I want % to appear below subtotal as a row. Please let me know how to obtain the % at the bottom of the report as a row.
Send me email with your report config screens to firstname.lastname@example.org
Hi,1 person found this helpful
By Using Union we can acheive this,
Send me a test mail,will show you how to do this,Last week the same rqmt i got and resolved.