1 of 1 people found this helpful
You need to pivot your data.
is this what yoiu want?
if so see the attached
first pivot the data Pivot Data from Columns to Rows - Tableau
so you get data that looks like this
make the viz and filter for the 2 rev fileds
then it is a table cal percent of total
and set the table calc to Cell
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
test_percentage_v2019.1.twbx 21.0 KB
I thought I had to reshape my table but I was still hoping there would be another way. just because my table is already so big.
Thank you so much!! works perfectly
is there a way to resturcture the data at the source? if not you could consider using Prep
Glad to help out