Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Are you able to share a sample where you are trying this out?
Try this expression: if(sum(total <Sales_Man,Order_id> Fact_X-Fact_Y)>30000,sum(Fact_X-Fact_Y))