Filter Values Greater than 1

[#1]

Hello,

I have a field called Values

            Values

              0.5        

              0.3       

              0.4        

              1.5        

              1.8         

              0.2

              0.3       

and I have a Pivot Table that has:

Name            Values      Volume

Totals              5.0          340

Blue                0.5          100

Red                0.3          50

Yellow             0.4          40

Black              1.5          20

Green             1.8          80

Orange           0.2          30

Pink               0.3          20

Is there a way to filter the values that are greater than and equal to 1 and less than 1?

Expected Output if greater than one is chosen:

Name            Values      Volume

Totals              3.3            100

Black              1.5             20

Green             1.8             80

and same with the less than

Thank you

Message was edited by: Roy Morales

[krishnacbe]

can you please share the expected output

[sunny_talwar]

Is this a dimension or expression?

[#4]

I have updated my question

[ciaran_mcgowan]

This will show everything greater than or equal to 1

     if(Values>=1, Volume)

And this will show everything less than

     if(Values<1, Volume)

If these are your only expressions, then any volume that doesn't meet you criteria won't be displayed.

[krishnacbe]

Hi,

PFA the sample qvw. hope that helps.

[Anil_Babu_Samineni]

Something Like this,

=If(sum({<[Comapny Name] = {"Volume>=1","Volume<1"}>})Sales)

OR

==If(sum({<[Comapny Name] = {"Volume" : ">=1 and <1"}>})Sales)

- Anil Chowdary

[#8]

You can done with this way, hope it helps

[#9]

How can i put formula where i have data from negative to positive and i need from -1 to +1..

[ciaran_mcgowan]

if(DATA >= -1 AND DATA <= 1, VALUE)