Hi
In below mentioned scenario, I am using below () function to copy stock value from previous day on current day under column “previous day stock”. Also calculating difference using below () function in formula and displaying difference in stock (Previous day stock – Stock) under difference column.
Now when we are enabling Show Partial sum at product and Product group level it not displaying total for the column “Previous day stock” and “difference in Stock”
Please someone can help us to display total in the column where below () function is used.
Showing the sample pivot table below for your reference
| Product Group | Product | Date | Stock | Previous Day stock | Difference in Stock |
| A | P1 | 10/28/2013 | 62190 | 128454 | 66264 |
| A | P1 | 10/29/2013 | 128454 | - | - |
| A | P1 | Total | 190644 | - | - |
| A | P2 | 10/28/2013 | 107870 | 238628 | 130758 |
| A | P2 | 10/29/2013 | 238628 | | |
| A | P2 | Total | 346498 | - | - |
| A | P3 | 10/28/2013 | 108098 | 243526 | 135428 |
| A | P3 | 10/29/2013 | 243526 | - | - |
| A | P3 | Total | 351624 | - | - |
| A | Total | | 1857116 | - | - |
| B | PC1 | 10/28/2013 | 350294 | 363574 | 13280 |
| B | PC1 | 10/29/2013 | 363574 | - | - |
| B | PC1 | Total | 713868 | - | - |
| B | Pc2 | 10/28/2013 | 350674 | 364284 | 13610 |
| B | Pc2 | 10/29/2013 | 364284 | - | - |
| B | Pc2 | Total | 714958 | - | - |
| B | Total | | 1428826 | - | - |
| Total | | | 3285942 | - | - |
