M
Matt
I have a table that has the following column headings
ID, Total # of Parts, Parts Not Included, and Percen
I want to add a row that calculates the totals for Total # of Parts and Parts Not Included. Then in that same row, I would like the Percent to calculate the Sum of (Parts Not Included/Total # of Parts). I tried going into the PivotTable View of the Table, but it does not allow me to use the Autocalculate button. All I want to do is add one totals row to my table
Any ideas of how to do this? Can I do it within PivotTable View
Thanks in advance
Matt
ID, Total # of Parts, Parts Not Included, and Percen
I want to add a row that calculates the totals for Total # of Parts and Parts Not Included. Then in that same row, I would like the Percent to calculate the Sum of (Parts Not Included/Total # of Parts). I tried going into the PivotTable View of the Table, but it does not allow me to use the Autocalculate button. All I want to do is add one totals row to my table
Any ideas of how to do this? Can I do it within PivotTable View
Thanks in advance
Matt