Set Analysis subset selection issues

[Krish]

I have a set analysis for a text object to calculate sum of all employees starting with 4.

sum({<empid={"4*"}>}sal)

But when a particular emp id like 4000 is selected, that is not showing for 4000 and still showing for all employees with 4.

How to achieve this.

[GaryGiles · Accepted solution]

You'll want to use an * before the equal sign to create an intersection between the currently available empids and the criteria specified in the set analysis, like this:

sum({<empid*={"4*"}>}sal)

[Anil_Babu_Samineni]

I agree with @GaryGiles here, But you can still try multiplying with dummy row alike.

sum({<empid={"4*"}>}sal)*Sum({$} 1)

[Krish]

Works perfectly. Thank you!!