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
