My data is like this and I need the third column as below defined.
I tried tableau default table calculation using percent from but it does the calculation like
Is there any other way to change the behaviour as the one I required.
I've created this using sample superstore sales data. Is this what you need?
Thanks john it worked also I multiplied your formula with 100 to get the percentage.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...