Need to "hide" Other and Unassigned rows in below pivot table without affecting either of Total rows. Please, note Industry column below is a second dimension but dragged to make it look like a column.
I think you should try to hide it by using an if statement. For example: if(Region<>'' or Region<>'Other',Region) . This way the unassigned and other regions won't be displayed in your table. Let me know whether it worked or not!
As mentioned, I have a pivot table (not Straight) ... and the post mentions hiding a row based on an expression value, my condition is to hide a row based on a Dim value and still not affect the Total.