Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Have numerous project numbers, labor hours by categories (such as
drafting, technician,, managment, etc.) In the PT and reporting on a single project, the labor totals can be broken into a "percentage of the total" by that category for that project, as it relates to the total of hours in the PT. However, if there are multiple projects in the database and more than one project is summarized and totaled in the PT, then the "percentage of column" will reflect a percentage; not of that item, but as a percentage of "all" the projects. I guess what we're looking for in the PT is a subtotal percentage for that project, and every projects' percentage would be equal to 100%. TIA for your thoughts. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column limitation | Excel Discussion (Misc queries) | |||
Embedded If Limitation | Excel Worksheet Functions | |||
Row Limitation | Excel Discussion (Misc queries) | |||
Way around row limitation | Excel Discussion (Misc queries) | |||
Cell Limitation | Excel Discussion (Misc queries) |