Pivot Table - Multiple Consolidation Ranges

XLML

Active Member
Joined
Aug 15, 2003
Messages
407
Hi ,

I have two worksheets. In Col A of both sheets is an account number. In Col B of Sheet1 is Actuals. In Col B of Sheet2 is Budget.

How do I create a pivot table with the account number in the row and the actual AND budget number in the data?

The layout using Row, Column, Page1 and Value confuses me.

Thanks in advance,
XLML
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

shades

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
In the Pivot Wizard, are you selecting "Multiple Consolidation Ranges"?

In the next dialog are you wanting to create the page fields or let Excel do it? Letting Excel do it on one page seems to work fine for this (unless I misunderstand).

On the last dialog, select the range, click Add, then select other range, and click Add.
 

XLML

Active Member
Joined
Aug 15, 2003
Messages
407
I got it to work by moving Page1 to the Column and Column off the layout. I don't understand why this works but it does.

Also what if I have 3 columns and I want col A & B (the Account # and Category) to appear in the Row section?

XLML
 

Forum statistics

Threads
1,147,690
Messages
5,742,653
Members
423,746
Latest member
Joaogomes

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