Hi
I generated a pivot table with C# that looks like this
Resource Class |
UNDEV |
PRE-DG1 |
DEV |
CUMPROD |
POST-DG3 |
UNCLARIFIED |
Grand Total |
CUMPROD |
|
|
|
649.7777398 |
|
|
649.7777398 |
DEV |
|
71.35799567 |
71.35799567 |
||||
POST-DG3 |
|
23.61363462 |
23.61363462 |
||||
PRE-DG1 |
|
117.9754108 |
117.9754108 |
||||
UNCLARIFIED |
|
13.53552061 |
13.53552061 |
||||
UNDEV |
3.2938108 |
3.2938108 |
|||||
Grand Total |
3.2938108 |
117.9754108 |
71.35799567 |
649.7777398 |
23.61363462 |
13.53552061 |
879.5541122 |
Resource Class |
UNDEV |
PRE-DG1 |
DEV |
CUMPROD |
POST-DG3 |
UNCLARIFIED |
Grand Total |
CUMPROD |
649.7777398 |
649.7777398 |
649.7777398 |
649.7777398 |
649.7777398 |
649.7777398 |
649.7777398 |
DEV |
71.35799567 |
71.35799567 |
71.35799567 |
71.35799567 |
71.35799567 |
71.35799567 |
71.35799567 |
POST-DG3 |
23.61363462 |
23.61363462 |
23.61363462 |
23.61363462 |
23.61363462 |
23.61363462 |
23.61363462 |
PRE-DG1 |
117.9754108 |
117.9754108 |
117.9754108 |
117.9754108 |
117.9754108 |
117.9754108 |
117.9754108 |
UNCLARIFIED |
13.53552061 |
13.53552061 |
13.53552061 |
13.53552061 |
13.53552061 |
13.53552061 |
13.53552061 |
UNDEV |
3.2938108 |
3.2938108 |
3.2938108 |
3.2938108 |
3.2938108 |
3.2938108 |
|
Grand Total |
3.2938108 |
117.9754108 |
71.35799567 |
649.7777398 |
23.61363462 |
13.53552061 |
879.5541122 |
Case2: I have this pivot table sample
Row Labels |
DEC-2011 |
DEC-2012 |
DEC-2013 |
DEC-2014 |
DEC-2015 |
DEC-2016 |
BP2011 |
102.4751271 |
86.16062842 |
101.9267757 |
116.1328398 |
144.2602586 |
161.8687039 |
Dev Total |
13.60451229 |
26.83958561 |
45.05291561 |
64.88848038 |
||
NFA Total |
88.44510789 |
77.496774 |
62.81541565 |
51.02899327 |
Row Labels |
DEC-2011 |
DEC-2012 |
DEC-2013 |
DEC-2014 |
DEC-2015 |
DEC-2016 |
Dev Total |
0 |
0 |
13.60451229 |
26.83958561 |
45.05291561 |
64.88848038 |
NFA Total |
0 |
0 |
88.44510789 |
77.496774 |
62.81541565 |
51.02899327 |
BP2011 |
102.4751271 |
86.16062842 |
101.9267757 |
116.1328398 |
144.2602586 |
161.8687039 |