pivot table expression condition

[#1]

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

[devarasu07]

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

[rahulpawarb]

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