I have a spreadsheet that includes four columns that have data associated for multiple rows. One column is the totals column for each row, and the remaining three columns have numbers that add up to the totals column. I am trying to create a pie chart that has the total number of data points as the dimension, but then the metric is each one of the three remaining columns shown as a percentage of the totals. I cannot figure out how to have each one of these pieces show in my pie chart. If I select "totals" as the metric, it will only allow me to choose one dimension, and splits that dimension out but the data in each row.
LinkedIn
Twitter
