# Help with pivot table

#### Island Girl

##### New Member
Good morning,
how do i create a pivot table for the following:

1. Compare all four location showing the each weekly and Monthly values.
2. Compare the monthly KWH for each location.
3. Compare the values for locations y and a.

location x
 week number of persons estimated kwh 1-6 nov 16 19 7-13 nov 16 38 14-20 nov 16 27 21-27 nov 16 20 28-27 nov 16 15 Month Total 38,000

<tbody>
</tbody>

Location y
 week number of persons estimated kwh 1-6 nov 16 5 7-13 nov 16 5 14-20 nov 16 6 21-27 nov 16 5 28-27 nov 16 5 Month Total 15,000

<tbody>
</tbody>

Location z
 week number of persons estimated kwh 1-6 nov 16 10 7-13 nov 16 10 14-20 nov 16 12 21-27 nov 16 11 28-27 nov 16 13 Month Total 44,000

<tbody>
</tbody>

Location a
 week number of persons estimated kwh 1-6 nov 16 27 7-13 nov 16 35 14-20 nov 16 33 21-27 nov 16 39 28-27 nov 16 30 Month Total 55,000

<tbody>
</tbody>

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### Rijnsent

##### Well-known Member
Hi Island Girl,
if you want that info in a Pivot Table you'd first have to standardize that information into one big table. E.g.:
Location - week - persons - estimated kwh
x - 1-6 nov 16 - 19 - 38,000 * nr of days in week / nr days in month?
x - 7-13 nov 16 - 38 - 38,000 * nr of days in week / nr days in month?
y - 7-13 nov 16 - 5 - 15,000 * nr of days in week / nr days in month?
etc...

Once you have your data in that format, you can use it as a source of a pivot table and after that you can generate the tables/reports you're looking for.

Hope that gets you started,

Koen

Replies
6
Views
343
Replies
7
Views
330
Replies
15
Views
490
Replies
6
Views
394
Replies
1
Views
112

1,191,381
Messages
5,986,300
Members
440,017
Latest member
vasanrajeswaran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back