13 Replies Latest reply on Jul 13, 2018 12:18 PM by Eason Chen

# What kind of calculation should I do for adding a percentage to each unique row?

See attachment, see sheet 3.

For example, I'd do "job count" over "opportunity count" for Q1 2016. That will be 49/436

But my calculation field gives the same number as "job count" for each row.

• ###### 1. Re: What kind of calculation should I do for adding a percentage to each unique row?

Try the following instead. See attached workbook.

SUM([Job Count])/SUM([Opportunity Count])

• ###### 2. Re: What kind of calculation should I do for adding a percentage to each unique row?

Thank you for helping.

I did exactly the same code but this time showed 0 for the row.

Did you do anything else to your attachment?

• ###### 3. Re: What kind of calculation should I do for adding a percentage to each unique row?

Just set the default formatting to be % with two decimal places.

• ###### 4. Re: What kind of calculation should I do for adding a percentage to each unique row?

my last question is where do you find that "formatting default" option?

• ###### 5. Re: What kind of calculation should I do for adding a percentage to each unique row?

See the following:

• ###### 6. Re: What kind of calculation should I do for adding a percentage to each unique row?

Thank you Ken for your patience. The problem is solved. Have a great day!

• ###### 7. Re: What kind of calculation should I do for adding a percentage to each unique row?

No problem. We love this stuff so we're always happy to help!!

• ###### 8. Re: What kind of calculation should I do for adding a percentage to each unique row?

Hey Ken, I accidentally hided the "data source"...um you know it contains "dimensions" and "measures" You know what should i do to unhide it? I'm trying to google it but my question probably too specific.

• ###### 9. Re: What kind of calculation should I do for adding a percentage to each unique row?

What do you mean you hid it? Can you show a screenshot?

• ###### 10. Re: What kind of calculation should I do for adding a percentage to each unique row?

I did this when I first started using Tableau.  Took me forever to figure it out!

Regards,

Gerardo

• ###### 11. Re: What kind of calculation should I do for adding a percentage to each unique row?

It's also in the menu window.

Regards,

Gerardo

1 of 1 people found this helpful
• ###### 12. Re: What kind of calculation should I do for adding a percentage to each unique row?

I just saw your message and Gerado got it. It was just the missing side bar.

• ###### 13. Re: What kind of calculation should I do for adding a percentage to each unique row?

Thanks Gerardo. I feel you, it drains my life looking for these minor "issue".

FYI, by clicking the "New Dashboard" also unhide the side bar for some reason, lol