How to hide particular row in pivot and not include it in calculcation

[deena279]

Dear Team

in the application requirement is to hide the '0' in ADD/G2 TOTAL units column, same way related values in other columns should be hidden. i can able to hide but the hidden value in IT INVOICE column is added in total. How to restrict the "9" to get added to the total. (please find the attached image)

expression used in IT INVOICE: 
Sum(Total<FIN_SKU,FIN_MONTH,FIN_YEAR>{<FIN_SOURCE={"INVOICE"},FIN_STATUS={"COMPLETE"},FIN_SHIPMENT_DATE={">$(Variable1)')FIN_QUANTITY)

[Anil_Babu_Samineni]

Perhaps this?

Sum(Total<FIN_SKU,FIN_MONTH,FIN_YEAR>{<FIN_SKU={"=Sum(Total<FIN_SKU,FIN_MONTH,FIN_YEAR>{<FIN_SOURCE={"INVOICE"},FIN_STATUS={"COMPLETE"},FIN_SHIPMENT_DATE={">$(Variable1)')FIN_QUANTITY)<>9"}, FIN_SOURCE={"INVOICE"},FIN_STATUS={"COMPLETE"},FIN_SHIPMENT_DATE={">$(Variable1)')FIN_QUANTITY)