You can't do this directly in Tableau - you'll have to move it to the data.
That being said, be very careful! This will make your data "taller" so the measures will not sum up correctly, as you will be duplicating them.
Hi Maggie, I believe you have to do two things.
These functions are great in Tableau, however, I think you'll find more success if your data is in the right format before you put it into Tableau.
Let me know if this doesn't work.
Yes, that is how I have always been doing it. But right now the data that I got is embedded in the twbx file and I unable to download it. That is why I was hoping to get this task done through tableau.
I was not able to pivot the data since both the columns are discrete and I don't have continuous measure to use.