Last answered:

29 Sept 2022

Posted on:

16 Nov 2021

0

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

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.

2 answers ( 0 marked as helpful)
Instructor
Posted on:

29 Nov 2021

0

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

Posted on:

29 Sept 2022

2

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

Submit an answer