Excel 2010
Hi, I have a simply count of cases in the values of my PP, and have fiscal year then fiscal quarter in the column label. I would like to add a SINGLE column or measure in the last column that annualizes the final year as I update it each quarter. However, if I create a measure it places a new column after every column I have in the pivot table.
Currently I have to build the entire pivot table with measurements to a achive this, but this requires that I manully update formula all the time. Plus I do not want to have to hide columns as this is a user interactive dashboard.
Thanks for any suggestions.
terry
Hi, I have a simply count of cases in the values of my PP, and have fiscal year then fiscal quarter in the column label. I would like to add a SINGLE column or measure in the last column that annualizes the final year as I update it each quarter. However, if I create a measure it places a new column after every column I have in the pivot table.
Currently I have to build the entire pivot table with measurements to a achive this, but this requires that I manully update formula all the time. Plus I do not want to have to hide columns as this is a user interactive dashboard.
Thanks for any suggestions.
terry