Hello All
See attached.
I am trying to use a pivot table to show me the following how much money I am spending monthly for each of my competency domains.
Example:
I am trying to use the pivot to calculate the total spent in periods 1, 2, or 3 divided by the Run Rate.
On sheet 2 with the pivot, I have provided a sample column of what I need the pivot to return.
I entered a calculated field into the pivot dividing by the run rate but it fails me.
Please let me know if I can add clarification?
Bookmarks