Pivot Table Layout Help

M

mardman

I have a Pivot Table that has two row fields listed in the layout. So
when you run or finish the Pivot Table it displays the row field
horizontally across the spreadsheet. I want to take them and displa
them vertically down the left side and can't remember how this is done
You can't just hoover over the field and drag it over there because i
then just moves the first field over to the left. I know this can b
done because I have performed this a long time ago and forgot how.
Please help... :eek
 
D

Debra Dalgleish

Drag the Data button into the Row area, to the right of the last row field.
 

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

First Pivot Table 4
re-using pivot table layout 1
Pivot Table Page Layout Questions 1
Different ways to build Pivot table 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Pivot table wizards 2
Pivot table data layout - columns to rows 1
Pivot ungrouping on refresh? 3

Top