This discussion is archived
1 Reply Latest reply: Mar 7, 2013 12:15 AM by Srini VEERAVALLI RSS

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

637686 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points