1 Reply Latest reply on Mar 7, 2013 8:15 AM by Srini VEERAVALLI

    how to get top 10 sales amount percentage over all sales amount

    637686
      Hi All,

      I need to generate a table/pivot table to pick FY13 top 10 sales amount by product (say P1, P2, P3, P4, etc), these top 10 total amount, percentage over total sales, comparing these top 10 in FY12 total sales amount, and percentage over total sales in FY12.

      EXAMPLE:

      FINANCIAL YEAR----------- FY13 TOP 10 SALES AMOUNT-------FY13 TOP 10 PERCENTAGE
      FY12--------------------------- 2M---------------------------------------------25%
      FY13-------------------------- 5M---------------------------------------------50%

      Thank you,
      Ling