1 of 1 people found this helpful
Some data formatting required make a pivot of your measures to get them from columns to rows.
After pivot your data will look like this
Then drag the fields like that. Change the format of % total to percentage.
Hope this help. Feel free to ask If you've any query.
Thanks for reply.
I forgot to mention, We have oracle database. I do not have pivot option ( Step 1) in tableau with oracle.
Thanks, It is working. I was thinking. Tableau must be having direct method to do this. Rather than creating separate field for this.
For that you've to transpose your data first. In my first reply I've done the same. But you can't pivot in db sources. One thing you can do transpose your data at database level using DECODE() function. Then connect to tableau. Then in a single calculated field you can achieve that. Hope you get my point.
Sent from my iPhone