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

    Chadi Atie

      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,

      Chadi