Pivot Tables and Stock Control (2) ' The answer
Reader Ray Yaukip needed a pivot table that gave the total of stock movements or of stock value between two dates. In Part 1 David Carter took a look at his data and outlined the problem. This week David looks at suggestions from readers, and also offers his own solution.
We've had five proposed solutions to this problem and all of them would work, I think. Serban Roman and Steve Shillitoe both had the idea of adding an additional column to the source worksheet.