Hi,
I'm using Excel 2010.
https://www.dropbox.com/s/2a8qn3g9dsy4alz/2015-04-10 Pivot Table Sum Total.xlsx?dl=0
In this Excel link you can view my file. It is a large pivot table. In column G, you see a field labeled "GIVEI Model". I'm interested in how I can have a sub-total that is displayed under each sector?
So for example, for Consumer Discretionary, I would want to see a GIVEI Model sub-total of 9.50%. Consumer Staples would be ~12.50%, and so forth.
Does this make sense? If not, I can be more descriptive.
Thank you,
James
I'm using Excel 2010.
https://www.dropbox.com/s/2a8qn3g9dsy4alz/2015-04-10 Pivot Table Sum Total.xlsx?dl=0
In this Excel link you can view my file. It is a large pivot table. In column G, you see a field labeled "GIVEI Model". I'm interested in how I can have a sub-total that is displayed under each sector?
So for example, for Consumer Discretionary, I would want to see a GIVEI Model sub-total of 9.50%. Consumer Staples would be ~12.50%, and so forth.
Does this make sense? If not, I can be more descriptive.
Thank you,
James