Here's I have problem. When I want to do pivot a dataset in excel I get into confusion that which column(s) have to place into COLUMNS/ROWS/VALUES/FILTER in the PivotTable Fields. How can I easily select a column from entire dataset which will go to right (COLUMNS/ROWS/VALUES/FILTER) place in PivotTable Area? Thank you.

First, you should visualize your report's look and then drag or assign your Pivot Toablefields by Rows, Columns, Values, and Filters.

Hello, Please think in terms of the table you would like to create. If you visualize clearly the table itself, then you will have a much easier time when creating it. Think about what you want to see and then start building it. Best, Ned

Follow this topic

Shafiqul Islam Shafiq

Last answered:

29 Sept 2022

Posted on:

16 Nov 2021

How can I easily select a column from entire dataset to place in PivotTable Area?

in Introduction to Excel / A Quick Introduction to Excel's Pivot Tables

2 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

29 Nov 2021

Falade Iyiola Ebenezer

Posted on:

29 Sept 2022

How can I easily select a column from entire dataset to place in PivotTable Area?

Submit an answer

related questions