2 Replies Latest reply on Sep 27, 2016 3:58 AM by harris.tsr

    From a table to a pie chart

    harris.tsr

      Hi everyone,

       

      Normally this should be a pretty easy task, but I'm still struggling for some reason. I have the following table view

       

      and what I want is to a) show the grand total of the columns, not rows. I've tried that from Analysis-total but it only shows the rows total, b) to display the sum as of percentages  as of shown below

       

       

      So, cluster 1 breakdown should be 15%, 2%, 6%, etc

       

      And finally, create 4 pie charts which will be split by the different dimension names.

       

       

      Any ideas would be much appreciated