CODEWITHSUNDEEP
excelpivot-table
Igor Gois
Igor Gois

Reputation: 73

Week average pivot table in Excel

I have the following data on excel:

day | week | #pieces

1 | 1 | 5

2 | 1 | 5

3 | 1 | 5

4 | 1 | 5

5 | 1 | 5

1 | 2 | 5

2 | 2 | 5

3 | 2 | 5

4 | 2 | 5

5 | 2 | 5

1 | 3 | 5

2 | 3 | 5

I did a pivot table that gets the total of #pieces per week.

Now I want to get the average of #pieces per week. I tried to use a calculated field using #pieces/5 but this is not always true for the current week. See week 3 for example:

Week | Average #pieces

1 | 5

2 | 5

3 | 2 (this number '2' should be also '5')

Does anyone know how to do that?

Thanks

Upvotes: 0

Views: 3034

Answers (1)

Nicholas Flees
Nicholas Flees

Reputation: 1953

As far as I understand what you're trying to do, you don't need a calculated field (which is messing you up, by the way, because you're dividing by the hard-coded 5).

I would pivot with week number as your row label and average of pieces as your values. You can change sum to average in the value field options of the pivot table.

Upvotes: 1

Related Questions