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

    hide complete pivot, when one field is null

      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.