2 Replies Latest reply on Jun 15, 2018 3:45 AM by Zhouyi Zhang

    Table Calculations w. clumsy Data

    Sebastian Thierfelder

      Dear Tableaus,

       

      I have on my hands a relatively clumsy data set, in the sense that it's not very well structured for Tableau use:

       

      RRP_KPI_Division.PNG

       

      As you can see, the measures are contained within the individual Month pills. The 'Measure Names' are the Months in the view. The 'Reporting Metrics' can be disregarded. The 'Measure Values' are the values contained within the Months/Measure Names.

       

      What I am trying to achieve: Divide the Blue Category by the Orange one, to get a Percent of Total.

       

      Any ideas?

       

      Much appreciated!!!

       


      Best Regards,
      Sebastian