3 Replies Latest reply on Sep 13, 2012 1:06 AM by Steven Taylor

    How to show columns without data when filtering

    Steven Taylor

      Hello,

       

      I have a table in a tableau workbook showing the order status of numerous orders as the columns (for example "On hold", "Cancelled", "dispatched", "received") with a count of the number of orders with each status.

       

      I would like to be able to maintain the same column headers when, via filtering on another field such as customer, no orders exist with one or more of the statuses available. At the moment when filtering on a customer with no orders "on hold" that column dissappears whereas I would prefer it to remain but with no data or a zero in the row.

       

      Any ideas?

       

      Many thanks,

       

      Steve.