# Pivot Table Help!!!!

#### Island Girl

##### New Member
[h=2]
Help with pivot table[/h]
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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### cyrilbrd

##### Well-known Member
Hi, you might want to consider changing the way your raw data is encoded.
For instance one single table containing the fields Location, Week, Number of persons, estimated kWh might be easier to work with.

#### Anand Sharma

##### Board Regular
Hi,

Normalize your tables into one with additional field identifying Data for locations as below and then use pivot table to compare

 Location week number of persons estimated kwh A 1-6 nov 16 27 X 1-6 nov 16 27 Y 1-6 nov 16 27

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

#### propi_

##### New Member
Hi,

Normalize your tables into one with additional field identifying Data for locations as below and then use pivot table to compare

 Location week number of persons estimated kwh A 1-6 nov 16 27 X 1-6 nov 16 27 Y 1-6 nov 16 27

<tbody>
</tbody>

Hi by normalizing Anand means putting it in one big table with the location column and then load it up to Power Pivot.

Then create the Measure :
Code:
``=Sum([estimated kwh])``

regards
Andy

Replies
1
Views
349
Replies
4
Views
210
Replies
3
Views
538
Replies
2
Views
132
Replies
0
Views
242

1,191,717
Messages
5,988,258
Members
440,146
Latest member
rgomes8

### 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