Hi
I have a classification entity (similar to the product catalog ) that includes parent classification id.
using this classification entity, i can create a product sector, product subsector, and product records.
Product is a child of product subsector. The product subsector is a child of the product sector.
I try to rename the Colum tile of a view (image 1) using a calculated field following the instruction from the link, https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Renaming-column-headers-in-an-entity-view/m-p/668202#M7018
I was able to create a calculated field to display Product sub sector (image 1). However, any suggestion on how can I get the Product Sector name (parent.parent.name).
Thank you, Siva
image 1
image 2