1 Reply Latest reply: Mar 7, 2013 2:15 AM by Srini VEERAVALLI RSS

    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
        • 1. Re: how to get top 10 sales amount percentage over all sales amount
          Srini VEERAVALLI
          Pull columns FinYear,SaleAmt,SaleAmt,SaleAmt in Criteria

          For 2nd SaleAmt use expression as top(SaleAmt ,10)

          use Pivot table
          Pull FinYear,top(SaleAmt ,10) in Rows section
          and other two SaleAmt in Measures

          for last column properties->Show Data As->Percent of ->Column

          The same works me.

          If helps mark

          Edited by: Srini VEERAVALLI on Feb 20, 2013 8:21 PM

          Any updates on this?

          Edited by: Srini VEERAVALLI on Mar 7, 2013 2:15 AM