Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
stantrolav
Partner - Creator II
Partner - Creator II

How to get (show) label of calculated dimension in textbox?

Hi..

I have 2 calculated dimensions in some chart.

1. =Aggr(If(Rank(Sum(PUB_EU))<=5 or ProductName = 'LERKAMEN' or ProductName = 'ZANIDIP-RECORDATI' , ProductName, 'Others...'),  ProductName)

2. =Aggr(If(Rank(Sum(PUB_EU))<=5 or ProductName = 'LERKAMEN' or ProductName = 'ZANIDIP-RECORDATI', Mol_Desc1, 'Others...'),  Mol_Desc1)

They have labels:

1. Product

2. Molecule

They are in cyclic group named

MainGroup

When i use function GetFieldSelections(MainGroup) there is nothing in my textbox.

But when i use straight dimensions like this without any calculation:

1. ProductName

2. Mol_Desc1

With the same labels written above, I get names of my dimensions: ProductName or Mol_Desc1. But not the labels that I defined for every of them. Is there some function to show Labels?

1 Solution

Accepted Solutions
Anonymous
Not applicable

1 Reply
Anonymous
Not applicable

11