4 Replies Latest reply: Jul 15, 2016 6:59 AM by Manoj Kulkarni RSS

    Pivot Table

    Manoj Kulkarni

      Hi Friends,

       

      Below is the sample data which i need to convert to pivot in expected format. Have attached both the details. How can we achieve this ?

       

      Any help will be appreciated.

       

      Input Data:

       

      REGIONCityValue
      EastBhubaneshwar22.9
      EastGuwahati1.9
      EastKolkotta1.9
      EastPatna5.4
      NorthChandigarh2.4
      NorthDelhi3.8
      NorthLucknow2.4
      SouthBangalore2.1
      SouthChennai4.3
      SouthHyderabad1.9
      SouthTrivandrum1.6
      WestAhemadabad2.1
      WestBhopal1.8
      WestMumbai1.8

       

       

       

      Expected result

       

       

      REGIONCityValue
      EastBhubaneshwar22.9
      EastGuwahati1.9
      EastKolkotta1.9
      EastPatna5.4
      East Total 8.0
      NorthChandigarh2.4
      NorthDelhi3.8
      NorthLucknow2.4
      North Total 2.9
      SouthBangalore2.1
      SouthChennai4.3
      SouthHyderabad1.9
      SouthTrivandrum1.6
      Total 2.5
      WestAhemadabad2.1
      WestBhopal1.8
      WestMumbai1.8
      Total 2.1
      Total 3.6