If you need the result in %, create a calculated field 'Ratio' > SUM([A])/SUM([B]). Click 'OK'. You should now see it under Measures, right-click > Hover over 'Default Properties' > Select 'Number Format' > Select 'Percentage' and Decimal Places you want. Attached screenshots,
Hope this helps.
Thank you for the screen shots and attached.
I am a “New” Tableau user.
Ideally, I would like to show both the numerator for all rows e.g.
Thank you, in advance for your help with this “newbie”.
image001.png 6.5 KB
Here’s the what the Sheet looks like.
The 1 and 3 under 2017 refers to 1 = Private Passenger Cars and 3 = Commercial.
Here how the it would work.
1 (Private Passenger Cars) 16-Losses Paid 1,391,737 would be divided by 1 (Private Passenger Cars) 11-Premium 1,041,539 for a Loss Ratio or 1.33 Or 133%.
3 (Commercial) 16-Losses Paid 842,526 would be divided by 3 (Commercial) 11-Premium 272,641 for a Loss ratio of 3.09 or a Loss ratio of 309%.
I know I’ll have to create a calculation for Loss Ratio – Not sure how.
Thank you.From: ShivaRam Chennapragada
Sent: Monday, April 09, 2018 10:57 AM
To: Bill Benton
Subject: Re: - How do I calculate ratios using the data in two columns to create a ratio?
Tableau Community <https://community.tableau.com/?et=watches.email.thread>
How do I calculate ratios using the data in two columns to create a ratio?
reply from ShivaRam Chennapragada<https://community.tableau.com/people/shivaram.chennapragada.0?et=watches.email.thread> in Forums - View the full discussion<https://community.tableau.com/message/748394?et=watches.email.thread#748394>
Where would I find the workbook?