how to create front end field in Scripting

[prma7799]

Hi All,

I want to create one field in back end(scripting).

using below  expression i want to create one field in back end

=aggr(if( rank(( ( sum({$<FiscalYear={$(=max(FiscalYear))}>}[Sales]))  /100000),4)<=20,Brand), Brand)

Can anyone help me out.

Thanks

[petter]

In the Load Script:

LET vSales = 'aggr(if( rank(( ( sum({$<FiscalYear={$' & '(=max(FiscalYear))}>}[Sales]))  /100000),4)<=20,Brand), Brand)';

In an expression in the UI:

$(vSales)

[prma7799]

Hi petter.skjolden,

Is this variable will work into nprinting,i want one field (top 20) for creating excel reports in Nprinting.

Thanks