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.
Bookmarks