1 Reply Latest reply: Mar 23, 2017 12:57 PM by omar bensalem RSS

    Filter Pane

    Robert Winkel

      I have a Pivot Table that I only want to display one description in a field.  I have tried a few things but I still have to select Data Entry to get it to work.  Is there a way to only display the one description upon opening the sheet?


      =Match(([Department Desc]) = 'Data Entry',[Department Desc])


      =If(([Department Desc]) = 'Data Entry',[Department Desc])

        • Re: Filter Pane
          omar bensalem

          Suppose your measure is : sum(sales)

          alter it as follow:

          sum({<[Department Desc]) = {'Data Entry'}>}sales)


          The result would be as follow:


          table 1 : measure : Sum([Car sales])

          table 2 : measure : Sum({<[OICA region]={'Africa'}>}[Car sales])