Pivot Table with dataSourceSettings.fieldMapping and Calculated Fields

Question

I have a Pivot Table that uses the dataSourceSettings.fieldMapping we map internal data name to human friendly data names.

This works well except when creating a new Calculated field.

When we drop a field into the formula field it is displayed with its internal name not the mapped name.

Manikandan Murugesan · Answer

Hi Thierry, 
 
When we drag and drop the fields, the corresponding field name is used in the calculated field formula. It is the default behavior of the pivot table in Microsoft Excel. And we're following Microsoft Excel's approach as well. Please find the attached screenshot below. 

Screenshot: 
  
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan

Thierry Tremblay · Answer

Thank you but I might not have explained my issue correctly.

In our Pivot table we have a field called 'f2528930', using the dataSourceSettings.fieldMapping option we map it to 'Customer ID'. So the user sees 'Customer ID' instead of 'f2528930' when using the pivot table. ( see screenshot )

This works perfectly everywhere except for the calculated fields. If the user drags the 'Customer ID' field to the formula it is displayed as 'f2528930' which can be confusing for users.

This has nothing to do with Excel standards. It is a display issue.

Manikandan Murugesan · Answer

Hi Thierry, 
 
We can't utilize field caption inside the formula because we can set the same caption to multiple fields in the pivot table. If we use field caption inside the formula, we won't be able to find the exact field name for further calculation. So, this is the correct behavior we followed in the pivot table. 
 
Please let us know if any concern occurs. 
 
Regards, 
Manikandan