Negitives in Straight Table

[#1]

Is there a way to limit a straight table to show only the negative results from an expression within the straight table?

Update with more details....

I have the following expressions:

Yr Potential Pay Impact:    If(Target-[Adjusted Actual]<0,Target-[Adjusted Actual],0)

Target:                               WorkRVU+[Contract RVUs])*Multiplier)/[Month Number])*12

Adjusted Actual:                Wage-Wage_Admin

There is also a flag to say if an employee has been with the company for 2 years

What I need to show in a straight table is only the employees whose [Yr Potential Pay Impact] <0   AND 2yr_Flag =No

Sorry for the poorly spelled out first attempt at a question, apparently my brain thinks its already the weekend!

Thanks for your help!

[#2]

Correct, all three of the expression I listed above are in the straight table.  I am just trying to limit the view of the straight table to where Yr Potential Pay Impact is negative (the 2Year flag I am not terribly worried about, it should be easy to include)

[bbi_mba_76]

Then you could add a calculated dimension with

If(2yr_Flag =No, employees)

and then hide this column in the presentation tab.

Then you could use the dimension limits tab to restrict the values to show only values that are less than 0 exact amount. In this way you could use the first expression to filter.

[#4]

I am not sure I understand, I think that would only solve the 2yr_Flag piece.  I am still unsure of how to show only the negitives for Yr Potential Pay Impact.

Sorry if i am making it more complicated then it needs to be!

[bbi_mba_76 · Accepted solution]

I loaded this table

where we have a dimension Dim, a flag, a measure and Abs to calculate negative values.

Using a calculated dimension I apply the first filter

Then I use the dimension limits

[#6]

Thats pretty cool!! Thanks for your help