ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pivot table excel (https://www.excelbanter.com/excel-discussion-misc-queries/234073-pivot-table-excel.html)

Jenny4r

pivot table excel
 
I have two worksheets set up. The first is an overall database recording the
names and types of a set of mechanical units, and tallies the total number of
each type of unit. This database does not change. I have another worksheet
which is a continuously growing record of maintenance on various units that
includes the date, the location of the unit by zone, and other bits of info.
I've generated a pivot table from this second worksheet and it is working
well. What I would like to do is take the grand total column/row created with
each pivot table and create another column/row along with it that calculates
what percentage the grand total is of the total number of units. For example,
if the grand total tells me that on a given day, this x number of units of a
specific type were repaired, the x number being the grand total, I want to
know what percent of the total number of units of that type (which I can get
from the first, non-changing database) is x? I know that I can use
GETPIVOTDATA to do this in a specific cell, but I'd rather be able to allow
the data to follow the pivot table in the same manner that the Grand Total
calculation does, to be a part of the pivot table and give the percentage of
whatever the data happens to be as I change the fields. Is there any way I
can do this? Thanks for any help you can give me!


Herbert Seidenberg

pivot table excel
 
Excel 2007 Pivot Table
Reference 2nd PT
http://www.mediafire.com/file/yyadcz...06_16_09a.xlsx


Jenny4r

pivot table excel
 
Thanks Herbert. I should have clarified that I am using Excel 2003.

"Herbert Seidenberg" wrote:

Excel 2007 Pivot Table
Reference 2nd PT
http://www.mediafire.com/file/yyadcz...06_16_09a.xlsx




All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com