Me again :) .... I notice you all have different little faces on your profile...how can I do that? Mine looks somewhat confused & angry...although that probably isn't too far from reality (the confused part) :)
Have an awesome day! and thank you all for welcoming me so warmly.
Sorry...is...
Hui- Awesome, this worked. Thank you very much. I kept trying "IF" calculated fields and everything else under the sun.
I originally wanted the same format as my original post with 2011 and 2012 above/below one another for each description and then the totals (by year as created with your...
I'm so sorry, I posted this in the wrong forum...
Here is the file. Please see my notes in red of what I am trying to accomplish. Any help will be greatly appreciated. Thank you all for your time.
http://www.2shared.com/document/LxV_lsII/Sample_Totals.html
Here goes a shot....
Globe Size 60-72
Description Data Year Weekending 08/31 09/15 Average
6428 40 lb Loose Avg Return Per Globe 2012 $0.06 $.11 $0.11
% of Total Cartons 2012 7.95%...
Hi, I found this site about 3 months ago and use it frequently for solutions to issues I run across.
You all are wonderful and I'm grateful I found you.
I have created a pivot table with information that is compared by year (inner rows). I need the subtotals to give me an average by year as well. Right now the subtotals are adding both years together.
Any help would be greatly appreciated.
Thank you.