Hi,
I have got a pivot table entries as below
Count Of Sum_Entry------ValColumn
Sum_Entry-------------------Val1---Val2---Val3---Grand Total
35--------------------------------X---------1---------2----------3
36--------------------------------1---------2---------10-------14
37--------------------------------3--------X----------5----------8
38--------------------------------4---------6---------X---------10
Grand Total-------------------8---------9---------17-------35
X represents empty values.
(Sum_Entry is placed in Row Labels, ValColumn is kept in Column Labels, Count of Sum_Entry is placed in Values )
Here i need a way to add the values from previous row to the next row.
Ex:The row starting with 36 should look like: (similarly for next rows....)
36------------------------1---------3---------13-------17
I'm not sure whether we can do this in pivot table. Can any one help me out on this?.
Bookmarks