4 Replies Latest reply on Jun 5, 2018 12:15 PM by Deepak Rai

Calculating a Percent based on Table Results and not on the underlying data

Hello, I'm really hoping someone can help with this question as I've been struggling with this for a while.  So basically to make a long story short, I have some data columns that are a bit apples and oranges so I have a number of manipulations going on underneath the surface to get the numbers to display in a table as needed.  However, when I try to calculate my Yield rate column (which is just Matrics divided by Offers), as you can see, I'm getting the percentages based on the underlying data and all I really want is to tell Tableau to calculate the percentages based on what is actually visible in my table.  So the first row should be 100% (12/12), the second row should be 8/18 (44.4%) and so on.  I've played around with various window functions but I just can't seem to get it right.  Any suggestions?

• 1. Re: Calculating a Percent based on Table Results and not on the underlying data

1 of 1 people found this helpful
• 2. Re: Calculating a Percent based on Table Results and not on the underlying data

attachment.

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to close Thread

1 of 1 people found this helpful
• 3. Re: Calculating a Percent based on Table Results and not on the underlying data

It's that simple?!  Ha, I actually tried this earlier but it was throwing an error flag for some reason.  Oh well, it's working now.  Thanks!  Sometimes the biggest obstacles having the simplest solutions.

• 4. Re: Calculating a Percent based on Table Results and not on the underlying data

It is just division of aggregated columns in your view.