locked
how to use Pivot table RRS feed

  • Question

  • 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