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