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
