0 Replies Latest reply: Nov 16, 2017 5:15 AM by Soniya Narayani RSS

    Vintage Analysis

    Soniya Narayani

      Hi All,

       

      Please find attached data

      I have Table1 like this and need to arrange like Table 2.Can somebody let me know what is the workaround i.e using in set analysis to get output like Table 2

      Table 1 :

      Row LabelsSum of Aug 2016Sum of Sep 2016Sum of Oct 2016Sum of Nov 2016Sum of Dec 2016Sum of Jan 2017Sum of Feb 2017
      Jul 201639351494276720321510
      Aug 20162121194254720011469
      Sep 20169784184917121258
      Oct 2016392194919901460
      Nov 2016173496266
      Dec 2016212
      Jan 201722
      Feb 2017
      Mar 2017

       

       

               

      Row LabelsMOB1MOB2MOB3MOB4MOB5MOB6MOB7MOB8
      Jul 2016 3 9 35 1,494 2,767 2,032 1,510 1,185
      Aug 2016 2 12 1,194 2,547 2,001 1,469 1,102 1,274
      Sep 2016 9 784 1,849 1,712 1,258 924 1,008 938
      Oct 2016 392 1,949 1,990 1,460 1,060 1,099 1,032 1,043
      Nov 2016 173 496 266 203 191 205 195 155
      Dec 2016 2 12 6 16 20 11 20 32
      Jan 2017 22 66 130 165 154 117 128 -  
      Feb 2017 37 80 79 90 83 105 -   -  
      Mar 2017 21 60 69 91 102 -   -   -