Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi petter.skjolden,
Is this variable will work into nprinting,i want one field (top 20) for creating excel reports in Nprinting.
Thanks