how to hide row in pivot table,

[#1]

how to hide row in pivot table,

help me thanks

[jagan]

Hi,

Using If statement set those rows expression values to 0 for the rows which you want to hide.

In a row if all the expression values are 0 then that row is removed by default.

Regards,

Jagan.

[#3]

Hi,

first write the if condition based on which field you want to hide on Add Calculated Dimension section in the Dimension section of in the pivot table.Then select or check the check box of suppress null value.I've Attached one application based on your requirement. hope it helps.

Warm Regards,

Arun Prasadh.N.