6 Replies Latest reply: Mar 23, 2016 11:19 AM by Christian Wylezol RSS

    hide complete pivot, when one field is null

    Christian Wylezol

      Hi everybody,

       

      I Need to solve one Problem with useless Pivot-table-data.

      I have a Pivot-table, which Shows all items, when there are items.

      But I have docnums as well which have no items.

       

      Now I wanted to hide the complete table, when no docnum is there to be shown.

      I tried with a conditional Show, but this does not work.

       

      IF(Count(distinct [docnum]) = 0,1)

       

      Does somebody can help me with that Topic?

       

      Thanks in advance.

      Chris