SAP Knowledge Base Article - Public

1345883 - How to get pivot table with dragging functionality in Excel 2007?


Need to have a pivot table in excel 2007 where fileds can be dragged directly in the grid.


1) Open Excel 2007.

2) Go to Insert tab>Pivot Table and assign a table or excel range.

3) Right click pivot table and go to PivotTable Options.

4) On the Display tab select the option "Classic Pivot Table layout (enables dragging of fields in the grid)".

See Also

Pivot, Layout, Drag


KBA , BI-RA-WBI , Web Intelligence , Problem


SAP BusinessObjects Xcelsius Enterprise 2008