1 Reply Latest reply: Feb 8, 2018 1:16 PM by Leonardo Contezini RSS

    Hiding values with under 30 responses in a pivot table

    Jordan Hertl

      I currently have a pivot table displaying Averages for some Topics.

       

      I was wondering if there was a way to have the cells come back as blank if there are under 30 survey responses?

       

      Thanks!

       

      Jordan

        • Re: Hiding values with under 30 responses in a pivot table
          Leonardo Contezini

          I don't know your data model, but I guess you could use a condition like:

           

          if(

               [Number of Survey Responses] < 30,

                                                                           null(),

                                                                           [Average Expression]

          )