Formula within set analysis not working

[Sammy]

Hi all

The following expression works:

=Count( {<Brand= {CD}>} Aggr( Count(Distinct Code),Shop,Code))  // Result=899

=Firstsortedvalue (Brand, -Aggr(Count({<Brand=>} Code), Brand), 1) //  Result = CD

This one is not working. I just replaced the brand CD on the first expression for the second expression which the result is CD

=Count(

{<Brand=
{
"${=
Firstsortedvalue (Brand, -Aggr(Count({<Brand=>} Code), Brand), 2)
}"
}

>}

Aggr( Count(Distinct Code),Shop,Code))  // Result = 0

What am I doing wrong?

Thanks

[Lizz_Johnston]

Hello,

Can you post a sample app with your expressions  for us to take a look at? 

[Wlad_Masi]

Maybe something like this:

=Count({<Brand= {"=$(Firstsortedvalue (Brand, -Aggr(Count({<Brand=>} Code), Brand), 2))"}>}Aggr( Count(Distinct Code),Shop,Code))

[Sammy · Accepted solution]

Hi, 

I solved my problem using variables

=Count({<Brand={$(vBrand2) } Brand)

Where vBrand2 was defined as a variable =Firstsortedvalue (Brand, -Aggr(Count({<Brand=>} Code), Brand), 2)

Thanks