I have one worksheet that has budget figures and one that has actuals.
Is there a way for me to combine these into a single pivot table.
"budget" and "actuals" should be different fields of course.

This sounds pefectly possible to me but you need to provide more details.

Is the data all in one Workbook or more?

"Shig" wrote:

I have one worksheet that has budget figures and one that has actuals.
Is there a way for me to combine these into a single pivot table.
"budget" and "actuals" should be different fields of course.
.

Hi,
summarize in one sheet your information one column called Budget and the
other Actuals, then run the pivot table

"Shig" wrote:

I have one worksheet that has budget figures and one that has actuals.
Is there a way for me to combine these into a single pivot table.
"budget" and "actuals" should be different fields of course.
.

Depends on the version of Excel - I per chance you are using 2010, yes I said
that, you can use PowerPivot to do it.

In 2007 and earlier you can use Microsoft Query and write a union query, but
you really need to know what you are doing.

The easiest way is to do as previously suggested - combine the data into a
singe range and pivot that.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Shig" wrote:

I have one worksheet that has budget figures and one that has actuals.
Is there a way for me to combine these into a single pivot table.
"budget" and "actuals" should be different fields of course.
.

I'm using Excel 2007, and the data is in one workbook but two
different worksheets. Other than using a Microsoft Query, it sounds
like the only way to do it is to combine the data into a single sheet
as suggested. Thanks.

On Jan 28, 3:34*pm, Shane Devenshire
wrote:
Depends on the version of Excel - I per chance you are using 2010, yes I said
that, you can use PowerPivot to do it.

In 2007 and earlier you can use Microsoft Query and write a union query, but
you really need to know what you are doing.

The easiest way is to do as previously suggested - combine the data into a
singe range and pivot that. *

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire



"Shig" wrote:
I have one worksheet that has budget figures and one that has actuals.
Is there a way for me to combine these into a single pivot table.
"budget" and "actuals" should be different fields of course.
.