• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

Pivot Table view

Hi all

I need to create a pivot table. in Office 2010
But the view I am getting is located in the picture below.

The expected view is shown in current situation  below.
Is there a way I can fine tune or set the properties of Pivot to display my expected view?


Current situation
Pivot current
My expectation
Expected solution
Thanks in Advance
0
ZURINET
Asked:
ZURINET
  • 2
1 Solution
 
redmondbCommented:
Hi, ZURINET.

Right-click inside the display and select "PivotTable Options..." to display the "PivotTable Options" dialogue. Click on the "Display" tab and select "Classic PivotTable layout (enables dragging of fields in the grid)". Click on "OK".

Edit: I've attached a couple of screen-shots in case the language difference causes problems.

Regards,
Brian...
0
 
redmondbCommented:
Thanks, ZURINET.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now