7 Replies Latest reply on May 3, 2013 9:54 AM by amanda.stanke

    Help with Manual Percentage of Total Calculation

    amanda.stanke

      Hi there,

       

      What I'm ultimately trying to do is show multiple labels on a pie chart that I've created - This reference material is fantastic but I'm not sure how to write out one of the manual calculations:

       

      http://kb.tableausoftware.com/articles/knowledgebase/adding-multiple-labels-to-pie-chart

       

      I work at a company that has multiple Business Units. Every quarter my department invests X amount of dollars into each Business Unit. Ultimately what I'm trying to display in my Pie Chart is:

       

      1. For Q2, how much money did we invest in each Business Unit (easy to do, I pulled in the SUM of our total quarterly investment, did a Quick Calculation so that the investment per BU is a little piece of the pie):

       

      BUs.jpg

       

      So I have the Investment by BU, which is great, and the Pie shows the % of that investment compared to total investment... But now I want to show:

       

      2. Next to the absolute $ value of the investment what the % value is. I am sure I can do it following the Tableau directions, but I'm not sure what the manual calculation would be that I would type in to update the label. For example, I can see that BU 2 was allocated about 50% of the total investment - I would like to show the $3.8 mil dollar amount next to the % allocation.

       

      Thanks for your help!