11 Replies Latest reply on Mar 28, 2018 7:23 AM by Herman Monama

    How to include null values and exclude other values? Please assist

    Herman Monama

      Hi Guys,

       

       

      I'm new to the forum and require assistance.

       

       

      I have to combined 2 dimensions (Cost Center and PO Number) in my worksheet, and I need to exclude any 'PO Numbers' that have 'Cost Centers', in other words I want to retain only the PO Numbers that have 'Null' Cost Centers.

      What's the easiest way to do this? Calc or filter???

       

      Please refer to below screenshot:

      Tableau desktop version: 10.2.10

       

      Please assist.

       

      Thanks in advance,

      Herman