Question

Which of the PivotTable areas is the one that displays category values from one or more fields arranged in separate rows?

Answer 1

After creating your PivotTable use the field list to change the design by adding and arranging the fields so your data is summarised exactly how you want, if you don't see the field list choose any cell in the PivotTable and then select analyze field list, select the fields you want in your PivotTable and they will be added to field areas, to move the field to a new area just click and drag it, filters area field are top-level report filters above PivotTable to focus on what you want, columns area field show up as column labels, rows area field shows up as row labels, both rows and columns filter the data how you want, values area field show as summary numeric values like sum or average with any of the areas, if you have more than one field you can rearrange the order to the position you want, which changes your PivotTable and you need to delete field just drag it out of its area.

Step for display multiple rows fields:

1. first, insert the PivotTable while click on any one cell on the table
2. you will find the list of fields from the given table with the value areas.
3. Just drag any of one or two rows field on the row field
4. the value field can be setting up what you want for a particular row like sum, count, average, max, or min.

For example, lets us consider one table for which will create the pivot table,

Now, will create the pivot table by selecting any one of the cell on the google sheet with help of data tab button.

On the row, will add two filed Category and Amount

now on the value field, select the field for which you want to sum, count, or average so, for example, we want to know to find out a number of fruit and vegetable as the well total amount of category for that will select category and amount then the pivot table looks like this: