Hello,
I am trying to get an expression working in the front end , which if calculated in the script has 2 group bys:
the expression is something like:
[Table 1]:
Load [key1], min(Item_key) as [min key]
resident [ABC]
GROUP BY [key1]
[Table 2]:
load min([min key]) as [min key]
resident [Table 1]
group by [key2]
when I use the field [min key] in an expression in a pivot table it works perfect..
However, when I use :
AGGR(MIN(AGGR(MIN(item_key), [key1])), [key2])) instead of [min key]
, it errors out....
but, when I display it in a separate pivot table against [key2], it works fine...
any clue what could be wrong...?
Many thanks.......
