I have a Pivot table that has a variable (set to Count) that has columns over a 10 year period. The last year/period represents only a potion of the year so I would like to "annualize" the last year/period data. I want to do this by dividing the last years count value by the ratio of days currently represented in the year to date (e.g., .141 for date in February). I've looked at calculated variables but it does not appear that you can work with a count value and modify it as I've described. I reuse the same pivot table for different data sets that (using VBA) that prohibits me from putting the pivot table value in a normal Excel cell and doing the calculations. I pull the values directly from the pivot table to a data select on an Excel chart.

Sorry for the delay. The problem with your solution is that you have a count variable in your original dataset. My count comes from using a variable in the data and using the Value Field Settings window to set the type calculation to Count (instead of sum, max min, etc.). So when I use your approach to go to Tools/Formulas/Calculated Field, the only variable that show are the original variables, not the count of a variable (or any of the other standard variable calculations). I've played around using a "count(variable name)/annualize factor" in the formula field (for calculated value). This seemed to give me a proper value, but it creates additional problems. I have grouped years and it appears that the calculated value makes some changes in the PT cache.

Thanks for thinking about this and providing recommendations.

John