Jarlisle
07-07-2009, 03:28 PM
I have a set of data (example provided) that I would like to get a lead aging analysis. I want to be able to show how much the RPL falls as the 'age' of the lead progresses. I want to use a pivot chart to do this so I can look at a single lead or multiple and have the pivot chart change accordingly.
I imagine that I would have to use a calculated item or field to get to that, but I can't seem to get it to work the way I want it.
In my example I have a calculation outside of the pivot table to show what I want.
I imagine that I would have to use a calculated item or field to get to that, but I can't seem to get it to work the way I want it.
In my example I have a calculation outside of the pivot table to show what I want.