Hi Sean - you will be able to do this with a Dynamic Calc. See below for screenshots of the setup. On your CV column, you would reference this member with one of the annotation View members, such as U8#Ent_Text1:V#Annotation.
Dim entity As String = api.Pov.entity.Name
Dim entityId As Integer = api.Pov.entity.MemberId
Dim entityText1 As String = api.entity.Text(entityId,1).ToString
Return entityText1
Hi Eric - can you explain how this can be altered to pull the Text 1 - Text 8 fields from the account dimension rather than entity?
Thanks!
Hello - you should just be able to change the code to reference Account (or another dimension) as well as the particular text field you are looking to retrieve:
Dim acct As String = api.Pov.Account.Name
Dim acctId As Integer = api.Pov.Account.MemberId
Dim acctText1 As String = api.Account.Text(acctId,1)
Return acctText1
