4 Replies Latest reply: Jun 23, 2014 12:06 PM by Prashant Sangle RSS

    sum into a table (without depending dimension)

      Hi Everybody.

      I don't find a solution to my problem. But i know that you're present with a solution.

      And so I say you : thanks ;-)

       

      My problem is the next one :

       

      My data source is :

       

      VehicleDate_of_ControlDefect_onCity_of_verification
      A

      11/02/2014

      MotorNY
      A11/02/2014BrakeNY
      A11/02/2014LightNY
      B11/02/2014NY
      C13/03/2014MotorBoston
      C13/03/2014BrakeBoston
      D10/09/2013WheelNY

      E

      01/06/2013Boston
      F24/05/2014BrakeBoston
      G26/05/2014Boston

       

      And the result must be :

       

      CityDefect_onQty_defect_Y2013Qty_defect_Y2014Qty_vehicle_verified_Y2013Qty_vehicle_verified_Y2014Col3/Col5Col4/Col6
      NYMotor

      0

      112

      0

      0.5
      NYBrake011200.5
      NYLight011200.5
      NYWheel101210
      BostonMotor011300.33
      BostonBrake021300
      BostonLight001300
      BostonWheel001300

       

      Thanks.