6 Replies Latest reply: Feb 8, 2013 1:24 AM by Sasi Nagireddy RSS

    Displaying % at the end of the report for every year

    user9255588
      Hi,

      I have a requirement, report should be in the below format

           Product Name     2007     2008     2009     2010     2011     2012 YTD
           1                              
           2                              
           
      Subtotal                              
           % total Amount     
                          
      I need to calculate the revenue for product for every year, In pivot view I am able to calculate the sub total, but i am unable to achieve % as displayed above. % is calcualted as
      (product revenue for year)/(revenue for year)*100. Please help me how to develop the report in the above format. Appreciate any help on this.

      Thanks
      Saru