Solved

Adding to Tables through a Pivot table

Posted on 2011-02-16
2
179 Views
Last Modified: 2012-05-11
How do I add expense A in Table 1 + an expense with the same name in Table 2 within the pivot table?
Thanks,
JP
0
Comment
Question by:easycapital
2 Comments
 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
Comment Utility
You cannot do that.  You can, however, add a column in Pivot table source 1, which sums expense in both data sources, then update the pivot table with the expanded range, etc.

If you need assistance, I can elaborate further.

Dave
0
 

Author Closing Comment

by:easycapital
Comment Utility
Good idea.
Thanks,
JP
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now