4 Replies Latest reply on Oct 17, 2017 3:27 AM by Francesca Grisanti

# How to Calculate the % of only the row total instead of the whole total

Hello Tableau Geeks,

I am new to Tableau and I want to some percentage calculations but could't find how, I will appreciate your help so much. Here is what I want to do:

I have this data below:

What I am willing to do is to calculate the percentage of each country alone for the whole row:

Let's take an example for Belgium, they have 50 Online Tickets, and 7 Offline Tickets, I need instead to show the percentage for January only as it will be something like this: Online (87%) and Offline (13%)

And repeat this calculation for each country on each month and do the same total for each quarter and finally for the whole year.

#### And IS THERE A WAY I CAN KEEP ONLY ONLINE DATA WITH THEIR PERCENTAGES AND HIDE THE OFFLINE DATA?

Is this possible? And how I can do it?

I have attached the workbook in case you guys can help me!

Cheers,

• ###### 1. Re: How to Calculate the % of only the row total instead of the whole total

maybe you need something like this?

Let me know!

• ###### 2. Re: How to Calculate the % of only the row total instead of the whole total

This is just perfect,

Thank you Francesca!

Cheers,

• ###### 3. Re: How to Calculate the % of only the row total instead of the whole total

I would be glad if you could also help me.

Thanks again.

1 of 1 people found this helpful
• ###### 4. Re: How to Calculate the % of only the row total instead of the whole total

I'll go asap!

1 of 1 people found this helpful