M
mutley
I am trying to create a pivot table that summarizes different overhea
categories and then reports each categories' ratio compared to revenu
(i.e. overhead category / revenue). My fields are called "Year"
"Month", "Indirect/Warehouse/Admin", "Overhead Category", and "Amount"
The "Indirect/Warehouse/Admin" field describes what general type o
overhead it is. The "Overhead Category" field describes the specifi
category. For example, there could be a category called "Salary" unde
each of the general types. I have the basic pivot table laid out.
Down the rows, I have the overhead categories grouped by thei
applicable type. Across the columns, I have the amounts summarized b
year.
Now comes the tricky part. I would like to add a column next to eac
year that reports the overhead amount as a % of that period's revenue.
If I did this right, the file is attached to this post. Any ideas
categories and then reports each categories' ratio compared to revenu
(i.e. overhead category / revenue). My fields are called "Year"
"Month", "Indirect/Warehouse/Admin", "Overhead Category", and "Amount"
The "Indirect/Warehouse/Admin" field describes what general type o
overhead it is. The "Overhead Category" field describes the specifi
category. For example, there could be a category called "Salary" unde
each of the general types. I have the basic pivot table laid out.
Down the rows, I have the overhead categories grouped by thei
applicable type. Across the columns, I have the amounts summarized b
year.
Now comes the tricky part. I would like to add a column next to eac
year that reports the overhead amount as a % of that period's revenue.
If I did this right, the file is attached to this post. Any ideas