3 Replies Latest reply on Apr 1, 2015 1:31 PM by rkomma

    hiding pivoted measure in pivot table

    rkomma

      Can we hide a empty pivoted column in a pivot table?

       

      In the below example measure 2 is only populated for type 1. so, can we hide/suppress measure 2 for only type 1?

       

      Example:

                                                         Type 1                                  Type 2                   

      name                             measure 1    measure 2          measure 1     measure 2

      sample 1                              90                                             7                    10

      sample 2                             100                                            7                    40

      -

      -

      -

      sample n                               5                                             7                    90

       

       

       

       

       

       

      Thanks,

      Ravi