8 Replies Latest reply: Mar 29, 2016 4:56 PM by michael pedersen RSS

    Custom row expression in a Pivot Table

    michael pedersen

      Hello,

       

      I have a Pivot Table where the last Dimension (active?) has Yes or No values.  I moved this field so it is the last 2 columns of my Pivot.  The expression is a sum of hours.  The pivot works great but now the customer would like to see the value of NO/YES as the last column.  I can't figure out a way to do this.  Any ideas?  I tried searching this forum and others before asking.  Any advice would be appreciated.

       

      Below is an image of what I am trying to do...

       

      help.JPG