expression based on filter and osuser

[joeybird]

Hi

I only wish to sum on person logged in

I have a text box that shows show's who's logged in via a windows login using

domain = OpenWorld

Username =jo111111

on text box expression is

osuser()

this gives me UserDirectory=OpenWorld;UserId=jo111111

I have a filterpane called UserId that contains jo111111

there is a chart showing sales, my expression is like this, but it does not work I only wish to sum on person logged in

sum ({$<OSUser= {UserID}>}SALES)

how can I get this to work please

[sunny_talwar]

Issue with "table chart on a sheet"? Not sure what we are talking about here?

[joeybird]

hi

I have used below

count({$<UserID = {'$(=SubField(OSUser(), '=', -1))'}>}CustID)

on table on a sheet...this gives me 0 or 1, how can I then limit the count to 1 on the table please?