2 Replies Latest reply: Oct 29, 2018 1:47 AM by Anil Samineni RSS

    Security Access Right Hide  Change Field Values.

    Riadh Chaouch

      HI,

      Very Urgent.

       

      This is the Table i have.

       

      TransactionCode

      CompanyCountrySalesAmount
      01BMWGERMANY50000
      02BMWGERMANY60000
      03BMWGERMANY90000
      04VOLKSWAGENGERMANY50000
      05MERCEDESGERMANY100000
      06PORSCHEGERMANY150000
      07FORDUSA90000
      08FORDUSA80000
      09CHEVROLETUSA30000
      10RENAULTFRANCE20000
      11RENAULTFRANCE30000
      12CITROENFRANCE40000
      13PEUGEOTFRANCE10000

       

      When i Access my app with BMWuser, i want to See:

       

      Table:

       

       

      CompanyCountrySalesAmount
      BMWGERMANY200000
      Germany Car 1GERMANY50000
      Germany Car 2GERMANY100000
      Germany Car 3GERMANY150000
      USA Car 1USA90000
      USA Car 2USA80000
      USA Car 3USA30000
      France Car 1FRANCE20000
      France Car 2FRANCE30000
      France Car 3FRANCE40000
      France Car 4FRANCE10000

       

      KPI's:

       

      BMW sale amount = 200000

       

      Total Germany Car sales = 50000 + 100000 + 1500000 = 300000

      BMW sales / Total Germany Car sales : 200000 / 300000 =  66 %

       

      Total Sales Of All Company in ALL Countries = 800000

      BMW sales / Total Sales Of All Company in ALL Countries : 200000 / 800000 = 25 %


      Thanks in advance.