Hide Certain Rows in Pivot

[Anonymous]

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.

Is such a scenario possible ?

Thanks.

Region	Industry	Total	Corporation	Unassigned	Public	Banking
Total		88%	61%	93%	63%	69%
Americas		13%	9%	3%	58%	49%
Europe		0%	27%	94%	86%	48%
Asia		15%	44%	55%	31%	18%
Other		24%	54%	31%	19%	41%

[#2]

Hi,

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!

Best,

Tibor

[Anonymous]

Hi Tibor,

It hides those values but also changes the Total values as well, need to keep them the same.

[#4]

Look at this thread. That should solve your problem.

Hiding rows based on condition

[Anonymous]

Ramkumar,

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.

Thanks.