Solved

# Pivot Tables - Calculated Value

Posted on 2011-02-22

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.