1 Reply Latest reply on Oct 13, 2017 4:30 AM by lenaic.ridinger

    Display columns in a table based on different dates

    Sairam Subramani

      I have a dataset in which (apart from a bunch of other data) there are two separate date fields. The difference between them is that one tracks dispatch and the other tracks arrival (of shipments).

       

      I am required to put together a table in Tableau such that some columns are based on "Dispatch Date" and others are based on "Arrival Date".

       

      [Let's take an example of a simple supply chain: Manufacturer --> Distributor --> Customer.

      I would like "Inventory at Distributor" and "Sales to Customer" numbers to be based on "Arrival Date".

      However, I would like to show "Sales to Distributor" numbers based on "Dispatch Date".]

       

      Is there a way I can do this on Tableau?