Pivot table help

S

sd

I am trying to create a simple Pivot table with data in the range A2:BC3

where row 2 holds the months jan-01, feb-01 all the way thru Jun-05 and row
3 holds the amount

Column A holds the header labels cell A2 has "Month" and A3 holds "Amount"

I select the range A2:BC3 and go to Pivot next,next ...

In the field list Pivot table shows me all the months whereas all I want is
2 field "Month" and "Amount"

However when i transpose the data it just shows those 2 fields which I can
easily group by year and quarter.

Was wondering if there is some setting that I need to change to tell the
Pivot table that the data is in columns and not rows

Or transposing the data first and then creating Pivot table is the only
route.

Please help
 
D

Debra Dalgleish

A pivot table uses the data in the first row of the source data as field
names, and there's no setting you can change to make it use the first
column data.

If you transpose the data, it should work correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Subtotals in a Pivot Table 1
grouping dates in a pivot table 1
Link Drop Down with Pivot Table 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Comparison 1
Pivot Table 3
Pivot table reorganizes when it shouldnt! 3

Top