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

SAP Knowledge Base Article - Public

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

Symptom

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

Resolution

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

Keywords

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

Product

SAP BusinessObjects Xcelsius Enterprise 2008