P
Peter
I have created a spreadsheet with 10 years plus of monthly energy consumption
and cost data. I am now trying to create a pivot table which will allow me
to compare monthly usage from one year to the next (Jan 99 compared to Jan 00
to Jan 01, etc) or, alternatively--using the Page field--to filter the report
by Average Daily Temperature. What I would like to see is the month/year in
Column A, KwH for that month in the same row in Column B, and Gas (in units
of CCF--Hundred Cubic Feet) in the same row in Column C just for starters.
What I am getting, however (either using the Layout wizard or not) is Date in
Column A (header on Excel line 4 with the data continuing down correctly in
Column A), BUT when I put KwH in the Column header field, it puts the KwH
header in cell B3 all right but then puts all the KwH data--which it arranges
in ascending order--on line 4 next to the Date header in cell A4.
Furthermore, when I try to enter something in the drop data field, the best I
get is a count of the item and not the data itself, and, at worst, I can't
get anything at all to work in the data field section and end up abandoning
the whole thing and starting over since Excel will not build the table any
further.
How can I get the pivot table to built properly, not give me "Count"
information when what I really want is the consumption data from the
spreadsheet, and organize it in a useable way? I would appreciate hearing
from anyone who can help me get past this logjam.
Many thanks.
and cost data. I am now trying to create a pivot table which will allow me
to compare monthly usage from one year to the next (Jan 99 compared to Jan 00
to Jan 01, etc) or, alternatively--using the Page field--to filter the report
by Average Daily Temperature. What I would like to see is the month/year in
Column A, KwH for that month in the same row in Column B, and Gas (in units
of CCF--Hundred Cubic Feet) in the same row in Column C just for starters.
What I am getting, however (either using the Layout wizard or not) is Date in
Column A (header on Excel line 4 with the data continuing down correctly in
Column A), BUT when I put KwH in the Column header field, it puts the KwH
header in cell B3 all right but then puts all the KwH data--which it arranges
in ascending order--on line 4 next to the Date header in cell A4.
Furthermore, when I try to enter something in the drop data field, the best I
get is a count of the item and not the data itself, and, at worst, I can't
get anything at all to work in the data field section and end up abandoning
the whole thing and starting over since Excel will not build the table any
further.
How can I get the pivot table to built properly, not give me "Count"
information when what I really want is the consumption data from the
spreadsheet, and organize it in a useable way? I would appreciate hearing
from anyone who can help me get past this logjam.
Many thanks.