3 Replies Latest reply on Mar 25, 2019 9:39 AM by yj.kim.1

    Please help me with combining data

    yj.kim.1

      Hello,

       

      I have a question about combining data in Tableau. (or could be in the data source?)

      I am getting my data from Access database.

      As you can see from the image and file that I attached, the problem I have now is my Access database is giving me the data that is 'Current Format' and I want it to be like the 'Ideal Format'

      To be clear, I don't want my data to consider the 'Type' and just combine the Amount, but I still want my data to be different and seperate Amount depend on the 'Year'.

      In my case, the unique identification key will be Account # + Year.

      Could anybody help me with this? Any good ideas?

       

       

      Thank you in advance.