2 Replies Latest reply on Jan 3, 2018 11:53 PM by Anshul Sharma

    Pie chart not adding upto 100%

    Anshul Sharma

      Hello,

       

      i have prepared a Donut chart by using dual axis, i have 5 brands in my data and their percentages does not add to 100 because we do not have data for the rest of the brands now my lead wants to display a separate category within this donut chart as 'Others' which will have the value (100-SUM(brand1 to brand5)) so that when the percentages are added they will sum up to 100. i have attached the workbook.

       

      Note: i am using an older version(9.3) of tableau desktop.

       

      please suggest.

      thanks