1.For eg . The cells A2:G20, A24:G42, A46:G64 in the attached file are the pivot Tables
2. The Pivot table 1 is the result of the source data. The result in column I is the result of the formula given manually. In Pivot Table 2 When the source data changed, the pivot is changed but the result in Column I is not changed and the result showed wrong calculation (calculated based on the formulas of Pivot Table 1). In Pivot Table 3 when the source data is changed the Pivot table changed and the result in column I is also changed as per number of products on a particular date. These changes are done manually for understanding. Is there a way to get subtotals as per date and number of products in column I dynamically?
The number of rows in column I should match with Pivot.
2. The Pivot table 1 is the result of the source data. The result in column I is the result of the formula given manually. In Pivot Table 2 When the source data changed, the pivot is changed but the result in Column I is not changed and the result showed wrong calculation (calculated based on the formulas of Pivot Table 1). In Pivot Table 3 when the source data is changed the Pivot table changed and the result in column I is also changed as per number of products on a particular date. These changes are done manually for understanding. Is there a way to get subtotals as per date and number of products in column I dynamically?
The number of rows in column I should match with Pivot.
f products and the calculation you have done on column I in the base data and pull that in the pivot itself.