7 Replies Latest reply: Sep 10, 2012 1:19 PM by gtsegay1 RSS

    Hide row(s) in a pivot table.

      1.How can I hide rows in a pivot table. I have Year as one of my dimension and I would like to hid the data for year = 2012?

       

      2. Also, is there a way to have a list box that excludes(hides) few of the selection when a sheet is activated?

       

      Thank you in advance.