Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have a pivot table. how can not show the value which is smaller than 1000. do i need to code in expression or is there way to do this thanks
Hi,
In your Pivot table expression try to put below kind expression,
Sum({<EmployeeID={"=sum(Freight)>1000"}>} Freight)
Refer to the sample attachment,
Hope this help to you
Regards,
Deva
Hello Gill,
Trust that you are doing good!
As you mentioned, you can code your expression in the required manner (expression definition or conditional at expression level) or you can devise a table with values less than 100 using resident load. Post that refer that table in presentation layer.
Hope this will be helpful.
Regards!
Rahul