Here I have got a table showing data and I want to to calculate how much percentage is the second row with the corresponding first row.
you can see in the attachment that I want to count how much percentage the the second row is for the first row each month.
For example For August month the percentage is Count of MonthReturned/Count of MonthOrdered. How can I achieve this.
I am new to tableau. So have less knowledge about it.
5 answers
Hi Dipen,
You can create a Calculated Field called "Percentage" with the formula:
COUNT([MonthReturned])/COUNT([MonthOrdered]).
Once created, right-click and change the number format to percentage. Then drag it to Measure Values. That should do the trick.
Let me know if you have any questions
Michael
