PIVOT TABLE QUERY 1

[VC2002]

Hi
Having problem with a pivot table

Data looks like this

Column1 Project Code
Column 2 Category
Column 3 Description
Column 4 Location
Column 5-16 Sept, Oct Nov etc

There are $ amounts under each of the months

On the PIVOT table I have Location as a Page field, Project, category and descrption in the row area, and the months in the data area.

Problem is the PIVOT doesn't show the months going accross the page it shows them like this (see below)

Any ideas please

Thanks



Description Data Total
Rental Cost Sum of Sep-04
Sum of Oct-04
Sum of Nov-04 750
Sum of Dec-04 800
Sum of Jan-05 900
Sum of Feb-05 900
Sum of Mar-05 900
Sum of Apr-05 900
Sum of May-05 900
Sum of Jun-05 900
Sum of TOTAL 6950

 

[xlbo]

Left click on the "Data" label and keep the mouse button held down
drag over to where it says "Total" and let go
et voila

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[SkipVought]

VC2002,

Problem is with the STRUCTURE of your data. Your data is NOT NORMALIZED.

NORMALIZE Your Table using the PivotTable Wizard faq68-5287

Your table structure ought to rather be
[tt]
Column1 Project Code
Column 2 Category
Column 3 Description
Column 4 Location
Column 5 Date
Column 6 Amount
[/tt]
The dates need to be REAL DATES. THEN in your PivotTable you can Group & Outline/Group - Month & Year on the Date Field Button.




Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[luceze]

On the pivot table toolbar click Auto Format. Select Report 1 as your format option. This will convert your pivot table into a columnar format. I'm sure there is a better way but this is the way that I do it.

HTH,
Eric