how to use Pivot table

• Question

• 

  

  0

  Sign in to vote

  Dear All

  I have data in table as below

  Order      Color     Size     Ratio   TotalQuantity

  1              Red       Med     1        100

  1             Green     Small    2        200

  1              Red       Large     1        100

  1             Green     Large     2        200

  I want to display it like
  

  Order      Color     Small      Med     Large    Total
  

  1              Red                      1         1            200

                  Green      2                      2            400

  2             Red                      1         1            200

                  Green      2                      2            400
  

  please help

  Regards

  Umair

               

  ---

  Thanks and Best Regards Umair

  Tuesday, December 27, 2016 3:59 PM