MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

Thanks.


Posted by Barrie Davidson on February 01, 2002 11:29 AM

You can use the GETPIVOTDATA function to lookup values in a pivot table. To get the syntax, look up GETPIVOTDATA in Excel's help.

Regards,
BarrieBarrie Davidson