Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
May 28, 2019, 3:15 PM

% of two columns - how

So I currently have this

 

Quantity Bin

 

Running Total XRunning Total Y0100500010020070002005009000

 

I want to show Running Total X / Running Total Y as % as a new column

 

How can this be done?

 

Thanks

5 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    May 28, 2019, 3:37 PM

    Hi Ravi,

     

    Firstly convert [Quantity Bin], [Running Total X] and [Running Total Y] to be dimensions:

     

    Hi Ravi, Firstly convert [Quantity Bin], [Running Total X] and [Running Total Y] to be dimensions: Place [Quantity Bin], [Running Total X] and [Running Total Y] on the rows shelf Create a new calculat

     

    Place [Quantity Bin], [Running Total X] and [Running Total Y] on the rows shelf

     

    Create a new calculated field:

     

    pastedImage_4.png

     

    Place this new field on the text shelf and you should have the result you were looking for.

     

    pastedImage_5.png

     

    I've attached my workbook. If this solves your issue please mark the answer as correct, if not let me know!

     

    Regards,

    J

Write an answer...
0/9000