Pivot tables help
Posted by Helen on February 01, 2002 10:33 AM
When you create a pivot table it summarises the left most column and only puts in one of the headings, and therefore leaving the rows below it blank. This is causing me real problems when I want to lookup to a pivot table or a sumif etc. Is there any way of filling down the data in the left summarised pivot? At the moment I am having to create a separate column to create this, but would love to know if there's a way to modify the pivot instead?