How to use Select in Field trigger for an AGGR calculated field?

[jblomqvist]

Hi all,

I have the following expression which creates a calculated list box:

=Aggr(Count(DISTINCT OrderID), ProductName)

I then have a sheet trigger based on above like this:

But it does not select in the list box as I thought it might.

Does anyone know how I can make this type of field selection work when someone opens the sheet please?

[neelamsaroha157]

You can create this calculation in the Script and then use the column for selection in trigger

[sunny_talwar · Accepted solution]

May be try like this:

Dimension

ProductName

Search String

='=Count(DISTINCT OrderID) = 259'

[jblomqvist]

Hi Sunny,

Just to explain this, is it because you have to evaluate the expression first?

Why do you have to use an equal again? (i.e. the equal outside the single quotes).

[sunny_talwar]

I am not 100% sure, but I think if you just use this =Count(DISTINCT OrderID) = 259 as your search string, it might work as well. But since I have never tried that, I wanted to give an expression which I was fairly confident would work. The idea is that everything within the single quotes is supplied as a search string for making selections in ProductName field.