Forum Discussion
Data consolidation
vschiralli You were just a few clicks away from the desired output. On the Design tab for the pivot table, select "Show in Tabular form" in the Report Layout group. and choose "Don't show Subtotals" in the Subtotals group. See attached.
Rajesh_Sinha Not sure I follow. See attached. Added a duplicate for PL2001 via sheet CiP02, though with a different Qty and thus a different weight. The total weight and PT updates as expected.
No Excel doesn't updated the PT.
What I've done.
- In Sheet CiPo2 to get new value, I've updated cell D23 with new value 400, and got 102 Kg in cell H23.
- Now in Cast-In Plates sheet excel updated the cell value with 102 kg in cell H12 & H1 with 522 Kg ( is formula bond ), but in PT the corresponding value in cell P3 remain 321.7401.
And when I refreshed the PT , Excel removes the Column SUM of 497, because the new value in PT cell P1 is 522 which formula bond SUM of 522, which Excel reads from cell H1, and is not the part of the PT, since PT has SUM of 497 as VALUE !!.
Check the attached file, also check the cells I've used in Sheets.