dynamic column names in Aggr

[ali_hijazi]

Hello

I have an expression in a pivot table as follows:

if(

min(aggr($(=vSales_Variance),[Geo Country],[Brand Group]))<0,

'qmem://<bundled>/BuiltIn/arrow_e.png')

the Columns [Geo Country] and [Brand Groups] I can get their names respectively using the following:

'[' & GetObjectField(Dimensionality()-1) & ']' 

however when I use '[' & GetObjectField(Dimensionality()-1) & ']'  in the above aggregation the expression doesn't work

Please advise

[#2]

up!

need it too

[whiteline]

Hi.

The field name should be calculated before the expresison starts calculating.

Use $() statement, something like this:

$(='[' & GetObjectField(Dimensionality()-1) & ']')