Is it possible to add a calculated field that doesn't apply to each column of data? For example, I have a data set that is pretty simple.

Please Login or Register  to view this content.

If I wanted to add a calculated field to the right side of this pivot table, that did the following:

sum(weeks)/(counta(Weeks)*40)

That would get me the percentage of utilization added to the right side. Right now, it wants to create a utilization for each week instead of a total.

Maybe it can be done wtihout even using calculated fields? I don't know.