I'm glad there is a great forum like this on the internet.

I essentially been working on a stock investment spreadsheet that I can use to track everything.
I have two sheets that are completely the same, except one has data for investment buy/sell transactions that I make and the other sheet is for re-invested dividends/distributions.

If I do PivotChart on just a single sheet I can get a table that looks like I want, but I need both sheets to get a complete look at everything. And I just can't get things to look the right way.

It might get a little confusing what I'm trying to accomplish, so I've included a screenshot of my data.

\1

Essentially the important data that I'm interested in is the securities I buy, the current value of the securities and the structure (tax structure) of it.

The ideal pivotchart would spit out something like this...
**dots are for structure
.................... TFSA.......RRSP
TDB911 .........123.00 ......456.00
TDB952 ......... 789.00 ....101112.00


Essentially, it would break down the totals of each security by tax structure. It works perfectly when I do one sheet, but when I try to do multiple sheets I just can't get what I want.

Am I missing something? Is this the way I should approach?

Thanks in advance.

Chris