2 Replies Latest reply on Mar 21, 2016 4:23 AM by Ganesh Vijay Kumar

    Best suitable graph for Pricing Analysis across all regions

    Ganesh Vijay Kumar

      Hello Experts,

       

      I am doing analysis on pricing at part number level.

       

      I have data at part number level. Which includes column names “Worldwide account Number”; “Worldwide account Name”; “Sold to account Number”; “Sold to account Name”; “Part Number”; “Region” and “Price”.

       

      All I want to know is:

      1. 1) What is the minimum price we are selling in different regions at part number level?
      2. e.g.

      Part Number

      Asia Pacific

      EMEA

      North America

      Others

      5-928999-1

      $ 6.95

      $ 6.95

      $ 7.73

      $ 6.95

      928999-1

      $ 6.95

      $ 6.95

      $ 7.64

      $ 6.95

       

      1. 2) The next drill through would be at Worldwide account Name.
      2. e.g.

      Part Number

      Asia Pacific

      EMEA

      North America

      Others

      5-928999-1

      $ 6.95

      $ 6.95

      $ 7.73

      $ 6.95

      ABC CORP

      $ 7.73

      $ 7.73

      $ 7.73

      $ 7.73

      LAB AG

      $ 6.95

      $ 6.95

      $ 6.95

      928999-1

      $ 6.95

      $ 6.95

      $ 7.64

      $ 6.95

      ABC CORP

      $ 7.64

      $ 7.64

      $ 7.64

      $ 7.64

      LAB AG

      $ 6.95

      $ 6.95

      $ 6.95

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      The next drill through would be at sold to account Name.

      Part Number

      Asia Pacific

      EMEA

      North America

      Others

      Grand Total

      5-928999-1

      $ 6.95

      $ 6.95

      $ 7.73

      $ 6.95

      $ 6.95

      ABC CORP

      $ 7.73

      $ 7.73

      $ 7.73

      $ 7.73

      $ 7.73

      ABC Automot.Syst.Ltd Sirketi

      $ 7.73

      $ 7.73

      ABC Automotive

      $ 7.73

      $ 7.73

      ABC Automotive Syst Ltd Sti

      $ 7.73

      $ 7.73

      $ 7.73

      $ 7.73

      ABC AUTOMOTIVE SYSTEMS

      $ 7.73

      $ 7.73

      $ 7.73

      $ 7.73

      $ 7.73

      ABC Automotive Systems Austria

      $ 8.10

      $ 8.10

       

      Could anyone suggest me which is best suitable graph for the above requirement with all the drill downs. Your help will be greatly appreciated.

       

      I have also attached sample data. Will be awaiting your positive response.

       

      Thanks,

      Ganesh