Analysis view: all calculated fields are lost when you add related fields

this is a documented known issue as seen from the documentation:

Analyze list page and query data using data analysis - Business Central | Microsoft Learn

Addressing this would require a design change.

Scenario (reproduction steps): 

• This is a standard base app bug , can be simulated on any BC environment in evaluation/CRONUS company.
• Search -> general ledger setup 
• Add value for field ‘Shortcut Dimension 3 Code’ = AREA
• Navigate to "Purchase Lines" page, it is possible to add the “Shortcut Dimension 3” (Area Code) field to the List page view (via personalization).
• Enter Analysis mode on the Purchase Lines table. 
• Field “Shortcut Dimension 3” (Area Code) is correctly displayed on the page in analysis view. It is possible to sort/filter or aggregate on this calculated field in analysis view. Group by this field also works correctly. 

• Now for the problem in analysis view: 
• Add related field(s) to the Analysis view for page "Purchase Lines" , example: 
• Analysis view -> Add columns from ->Other Source -> Item , Via No. = No.  
• Add field Item category Code 

• Result: In the resulting analysis view , the column “Area Code” (calculated field) does not display the related value anymore (column shows as empty now) , as soon as the “add columns from” functionality is used on the analysis view. 

• Reason: as mentioned , this is a documented known issue as seen from the documentation: 
• Analysis view: all calculated fields are lost when you add related fields

• Request: 
• Our customers want to make analysis views with related fields included correctly , without losing calculated fields in the analysis view.