Home

Excel Pivot Calculated Fields from Same Colum

%3CLINGO-SUB%20id%3D%22lingo-sub-612579%22%20slang%3D%22en-US%22%3EExcel%20Pivot%20Calculated%20Fields%20from%20Same%20Colum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-612579%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20data%20table%20which%20has%20a%20column%20named%20%22Year%22%20which%20includes%202019%2C%202018%2C%202017.%20I%20want%20to%20create%20a%20calculated%20field%20called%20growth%20which%20divides%202019%2F2018%20but%20I%20only%20find%20the%20field%20year%20and%20not%20the%20detail%20of%20the%20column.%20What%20can%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-612579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615282%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Calculated%20Fields%20from%20Same%20Colum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615282%22%20slang%3D%22en-US%22%3EIf%20you%20have%20Excel%202016%20you%20could%20load%20your%20data%20to%20the%20Data%20Model%20and%20then%20write%20a%20DAX%20formula.%20This%20happens%20with%20Power%20Pivot.%20Have%20you%20got%20Excel%202016%20(or%20you%20can%20get%20an%20addin%20for%20Excel%202013)%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EDAX%20formulas%20are%20more%20flexible%20and%20powerful%20then%20the%20older%20Calculated%20items%2Ffields%20in%20Pivot%20Tables%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615347%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Calculated%20Fields%20from%20Same%20Colum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%2Cas%20a%20comment%2C%20that's%20not%20necessary%20to%20have%20Power%20Pivot%2C%20DAX%20measure%20could%20be%20added%20from%20PivotTable%20interface%20if%20data%20is%20added%20to%20data%20model.%3C%2FP%3E%3C%2FLINGO-BODY%3E
ralechuga
Occasional Visitor

I have a data table which has a column named "Year" which includes 2019, 2018, 2017. I want to create a calculated field called growth which divides 2019/2018 but I only find the field year and not the detail of the column. What can I do?

2 Replies
Highlighted
If you have Excel 2016 you could load your data to the Data Model and then write a DAX formula. This happens with Power Pivot. Have you got Excel 2016 (or you can get an addin for Excel 2013) ?

DAX formulas are more flexible and powerful then the older Calculated items/fields in Pivot Tables

@Wyn Hopkins ,as a comment, that's not necessary to have Power Pivot, DAX measure could be added from PivotTable interface if data is added to data model.

Related Conversations
Problems using Pivot tables in Excel 16.25 on Mac
jeromepineau in Excel on
0 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Freeze Pivot Chart
ianpercy in Excel on
0 Replies