Help with pivot table

[Island Girl]

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>

Your assistance is greatly needed!!!!!

 

[Rijnsent]

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