I’m transfering data from Navision to Excel using Pivot Tables. I want to create (by code) a CalculatedField in the pivot table… but I don’t find the way. If I doit in Excel and I see the VisualBasic code I see the following sentence: ActiveSheet.PivotTables(“Tabla dinámica1”).CalculatedFields.Add “Field1”, _ “=X / Y” ActiveSheet.PivotTables(“Tabla dinámica1”).PivotFields(“Field1”).Orientation = _ xlDataField But I don’t know how to translate theese orders in C/AL If you know how do it, please help me… If I don’t find another way I will do a macro in Excel and call the Macro from Navision.