1 Reply Latest reply on Dec 29, 2018 7:29 PM by Rodrigo Calloni

    Current, Prior and Difference for multiple measures in single sheet

    Kanhu Gouda

      Hi Everyone,

       

      I am looking for a view like below in a single sheet.

      The date range values (Current Year, Previous Year and Difference) should be displayed for each category even though the measure data could be null for that category.

      Please help me how to achieve it. I am using Tableau 10.5 version.

        

      CategoryDate RangeSalesProfitQuantity
      FurnitureCurrent Year10000400100000
      Prior Year20000500200000
      Difference-10000-100-100000
      Office SuppliesCurrent Year10000300400000
      Prior Year15000150500000
      Difference-5000150-100000
      TechnologyCurrent Year1000005000700000
      Prior Year60000400800000
      Difference400004600-100000