I am creating a pivote table with 2 dimension D1(Vertical) and D2(Horizontal) which is using expression value of above row + Some new values . For this I am usin Rangesum(Expr...).
D1 D2 A B C
1 10 25 12
2 18 36 28
3 23 47 37
4 30 53 49
5 47 60 58
6 49 69 63
7 55 80 77
8 55 87 79
9 55 87 83
10 55 87 87
This works fine. But when I use some filter it removes D1 values for which there is no corrosponding transaction for that selection and the values doesnot appear correct in the chart. I have found one workaround by including Dummy data for every possible selections with 0 value but it is increasing my application Size exponentially. Is there any other way to do this ? Hope I have explained my question correctly.
