How should we write the expression in this condition............?

[srinivas1921]

Hi,

I have a Pivot table with fields Sales_man,Order_ID,Product_ID,Fact_X,Fact_Y,Fact_Z.

Here one Order_ID consists of Different Product_ID's and Fact_Z  is derived  from Fact_X,Fact_Y( Fact_Z=Fact_X - Fact_Y ) and as per my requirement I want to see  this Pivot table chat results with only Fact_Z > 30000.

I mentioned above condition expression in every filed to get this result but I couldn't get  correct result.The below highlighted in the image is the Expected result.Kindly provide the solution for this scenario.

[sunny_talwar]

Are you able to share a sample where you are trying this out?

[Gysbert_Wassenaar]

Try this expression: if(sum(total <Sales_Man,Order_id> Fact_X-Fact_Y)>30000,sum(Fact_X-Fact_Y))