1 Reply Latest reply on Oct 1, 2014 3:31 PM by diego.medrano

    Top n Products in Sales, then 100% stack bar chart represents the totals sales in each categories.

    jack lu

      Hi All,

       

      First of all, thanks for taking a look at my question. I'd be really appreciated if you could give me an solution.

       

      I have a excel spreadsheet below like 400,000 rows. I would like to first filtered the Top 5 sales product of each county - for example I United States. Then do a 100% stacked bar chart to show the % of sales which these top 5 products belongs to each month. Is there a ways to do this? Thanks.

       

       

      Product NamesCategoriesCountriesPeriodRevenue
      A001CasualUnited States8/12/2013500000
      A002StrategyUnited States4/1/2013500000
      A003CasualUnited States7/2/201350000000
      A004PuzzleUnited States8/2/2013200000
      A005SportFrance9/12/20139999999
      A006RacingFrance10/2/20135000000
      A007StrategyFrance11/2/201387777777
      A008StrategyGermany11/3/2013974845145
      A009StrategyGermany11/3/201348456115
      A010CasualUnited States11/3/20132233
      A011StrategyUnited States11/3/2013215415
      A012CasualUnited States11/3/2013211
      A013PuzzleUnited States11/3/201384513
      A014SportFrance11/3/2013755165
      A015RacingFrance11/3/20138613
      A016StrategyFrance8/12/2013861321
      A017StrategyGermany8/12/20137845613
      A018StrategyGermany8/12/20138465312
      A019CasualUnited States8/12/2013845630
      A020StrategyUnited States8/12/201387456132
      A021CasualUnited States8/12/201378542
      A022PuzzleUnited States8/12/2013894651
      A023SportFrance8/12/20138465
      A024RacingFrance8/12/2013846513
      A025StrategyFrance8/12/201384651
      A026StrategyGermany8/12/201321684
      A027StrategyGermany4/1/201348
      A028CasualUnited States4/1/20138946
      A029StrategyUnited States4/1/2013894984
      A030CasualUnited States4/1/20131561318
      A031PuzzleUnited States4/1/2013846131
      A032SportFrance4/1/2013846513
      A033RacingFrance4/1/2013945320
      A034StrategyFrance4/1/201385163
      A035StrategyGermany4/1/201378542
      A036StrategyGermany4/1/201394984651