firstsorted value in set analysis

[kris_vliegen]

Hello,

I try to use the first-sorted value in a gauge-chart.

I'm making a dashboard for fuelstations.

I would like to create a gauge-chart by petroltype.

But not every fuelstation has the same petrol-type's.

In a textbox I can show the Artikel by  =FirstSortedValue(ARTNKey,ARTNID,3)

In the gauge-chart I would like to do something like this

=sum( { $ < CalYear = {$(vCurrentYear)}, [~Type] ={'T'}, ARTNKey={"=FirstSortedValue(ARTNKey,ARTNID,1)"} >}Quantity) /

sum( { $ < CalYear = {$(vPrevYear)}, [~Type] ={'T'}, ARTNKey={"=FirstSortedValue(ARTNKey,ARTNID,1)"} >}Quantity)

But this is not working...

Who canhelp me?

Regards,

Kris

[Gysbert_Wassenaar]

Maybe like this:

=sum( { $ < CalYear = {$(vCurrentYear)}, [~Type] ={'T'}, ARTNKey={"$(=FirstSortedValue(ARTNKey,ARTNID,1))"} >}Quantity) /

sum( { $ < CalYear = {$(vPrevYear)}, [~Type] ={'T'}, ARTNKey={"$(=FirstSortedValue(ARTNKey,ARTNID,1))"} >}Quantity)

[#3 · Accepted solution]

try,

ARTNKey = {'$(=(firstsortedvalue(ARTNKey,ARTNID,1)'}

regards,

MT

[kris_vliegen]

Thanks Magdalena,

This is working ARTNKey = {'$(=(firstsortedvalue(ARTNKey,ARTNID,1)))'}

Regards,

Kris