1 Reply Latest reply: Nov 16, 2017 11:45 AM by Sunny Talwar RSS

    Vintage Analysis

    Niky Rathod

      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 Labels

      Sum of Aug 2016

      Sum of Sep 2016

      Sum of Oct 2016

      Sum of Nov 2016

      Sum of Dec 2016

      Sum of Jan 2017

      Sum of Feb 2017

      Jul 2016

      3

      9

      35

      1494

      2767

      2032

      1510

      Aug 2016

      2

      12

      1194

      2547

      2001

      1469

      Sep 2016

      9

      784

      1849

      1712

      1258

      Oct 2016

      392

      1949

      1990

      1460

      Nov 2016

      173

      496

      266

      Dec 2016

      2

      12

      Jan 2017

      22

      Feb 2017

      Mar 2017

       

      OutPut Required :

       

       

      Row Labels

      MOB1

      MOB2

      MOB3

      MOB4

      MOB5

      MOB6

      MOB7

      MOB8

      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

       

      Trying to do it in front end as backend load script is not possible with the current data model