Adding Annualized column to PP without it dupilcating after each column

tbobolz

Board Regular
Joined
Mar 18, 2010
Messages
142
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
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Tianbas

Board Regular
Joined
Apr 29, 2014
Messages
101
You can use a set (Options->Fields, items & sets->Create a set based on columns) to hide the annualized measure in all (pivot) columns beside the last one. This should also work for a user interactive dashboard.

Cubeformulas would be another option if a pivot is not really needed. Using different time periods with Cubeformulas is easier than creating measures for that in a pivot.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,120
Messages
5,412,556
Members
403,432
Latest member
cr2141

This Week's Hot Topics

Top