3 Replies Latest reply: Sep 16, 2009 1:26 PM by NigelWest RSS

    hide pivot table column

    JASON SIGFRED SERIL

      hello all,

      i've searched the discussion forum regarding the issue and the answers were all archived, so i would like to ask what is the process (set analysis...) on hiding the pivot table columns ("Team, Branch, Employee Name") when "Etc" is selected. please find the image below.

      error loading image

      i really appreciate if somebody knows how. thank you very much in advance.

      regards,

      jason

        • hide pivot table column
          WedgeA

          1. You could use a calculated dimension ( if(Category='Etc', Team) ). But I dont think it is a great solution because you get empty columns.

          2. You could use a macro and a button.

          sub AddDimension
          set Graph = ActiveDocument.GetSheetObject( "CH04" )
          Graph.AddDimension "GES_NR"
          end sub


          3. You could create several pivot tables and only show one, depending on a condition (->Chart Properties->Layout->Conditional).

           

          All three options arent optimal, so maybe someone can come up with a better solution