When you right click on a pivot table row and select keep selected items it let's you do this by highlighting certain rows that aren't consecutive. If you select non consecutive rows and right click and do hide selected items it doesn't work. Why is this or is it just a problem my end? Thanks
