Hi
I have attached a simple Pivot file. Basically my data is some ratios, by year by stock.
BHP OST
Ratio 2008 2009 2008 2009
ARatio 2 2.1 3 2.9
BRatio 1.1 1.4 1.5 1.6
I want calculate the average of the ratios by year (but not by stock) and I don't want to use the Total Column/Row function as I really want the averages on the left of the table so I can split the screen as I scroll across.
So I was hoping on some result that looked something like:
AVERAGES BHP OST
Ratio 2008 2009 2008 2009 2008 2009
ARatio 08Avg 09Avg 2 2.1 3 2.9
BRatio 08Avg 09Avg 1.1 1.4 1.5 1.6
So I am playing around with calculated fields but just can't get the right outcome.
Any help greatly appreciated
Thanks
Matt
Bookmarks