pivot tables

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591
Hi All:

I have a dilemna I need your guidance on. When I use Excel XP for pivot tables I get the option of "Add to" when I click finish. This Add to function allows me to add to columns and rows.

The only problem is when I try to create pivot tables in Excel 2000 it doesn't have that feature.

How can I add this feature to Excel 2000, or is there another way of adding to rows and columns using some menu.

Thanks in advance for your help,

BA
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

nate

New Member
Joined
Oct 22, 2002
Messages
6
Hi,

Reckon you want to change or add to pivot table after it has been created.
After setting up initially via "layout," continue on to finish. Your pivot table will appear, along with a pivot table toolbar. If the toolbar does not appear, please resolve via view, toolbars, pivot table.
2, Pivot table will also display your pivot table's fields - but it will only do THIS if your first click in the body of the pivot table.
3, One other chance to go astray - pivot table toolbar will have a bunch of selections - "always show field list." "always hide field list." etc.
You may want to experiment with the buttons here, but need to have first clicked in the pivot table body, in order to get the full picture.

hope this helps!
regards
 

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591
I tried all of these and no option gives me the opportunity to add to the columns or rows in Excel 2000. I have experimented with all the buttons and the toolbar for the pivot table is always there.

Does anyone know how I can add to rows and columns in Excel 2000. In Excel 2002 in the box that appears with all the fields the add to option is right at the bottom but this is not the case in Excel 2000.

BA
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
not entirely sure that I know what you want? If you want to know how to amend the look of your pivot table by adding fields in the horizontal and vertical columns then right click the pivot table, do to wizard and then layout. But I think this has been mentioned already.

Can you be a little more specific when you say you want to "add rows or columns" - do you mean the data making up the pivot table, the pivot fields, the pivot dropdowns - what exactly?
 

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591

ADVERTISEMENT

Here is the desired result I am looking for. This is from Excel XP 2002.
Book1
ABCDEFG
4CostElementOrderBudget/ActualAprMayJunJul
55133000700027Actual1,5100417417
6Budget2702702701,670
7700028Actual00417417
8Budget540540540540
9700356Actual4171,66701,770
10Budget2,0501,8001,8002,050
11700361Actual010400
12Budget2502502502,000
13700472Actual001390
14Budget000810
15700474Actual0000
16Budget0001,400
17701350Actual0000
18Budget000850
19701351Actual0000
20Budget0000
215133000Total
Sheet1


I am unable to produce the same result in Excel 2000. When I try to add the months to the columns using layout it put the numbers above the table.

Does anyone know how to produce the same result in Excel 2000?

BA
This message was edited by baggarwal on 2002-10-24 20:31
 

ThePencilQueen

Board Regular
Joined
Jun 26, 2002
Messages
109
Are you saying that it displays each month as a new row?

actual|apr
actual|may
actual|jun
Actual|jul
budget|apr
budget|may

etc etc?

If this is so just click on the data tab on your actual pivot table and drag it underneath the total cell...this should display the different months horizontally instead of vertically.

If not an example of what it looks like (as well as the example of ahwt you want you already posted) should give us a better idea what the problem/solution is.
 

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591
This is the output I am getting from Excel 2000 when I go into the layout and add the months to the columns.
Book1
ABCDE
2
3SumofMayAprMay
4100166
5CostElementOrderBudget/Actual1000
65133000700230Actual
7Budget
85133000Total
95133200700231Actual
10Budget
11700241Actual
12Budget
13700245Actual
14Budget
15700247Budget
16701365Budget
17701376Budget
185133200Total
195133210700829Budget
205133210Total
Sheet1


How can I convert this output to the output produced by Excel XP. I really do wish that Excel 2000 had the Add to box at the bottom of the selection screen that shows you all the fields you can add to the pivot table.

Mark, your method would require too much manual work. I have about 600 groups of orders that I would have to add lines to.

Does anyone know how I can modify the Excel 2000 version of the pivot table to the desired XP 2002 one.

Thanks again for your help,

BA
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
600 orders? Using the approach described at the link above... that should take fewer than 15 minutes.
This message was edited by Mark W. on 2002-10-25 18:10
 

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591
If I can add to columns and rows in Excel 2000 the way I could in Excel 2002 it would take seconds for me to produce the end result.

Is there anyway I can get Excel 2000 to allow me to add to row and columns the way I can in Excel 2002?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,054
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top