3 Replies Latest reply on Oct 18, 2018 11:33 AM by Deepak Rai

    Adding in % of totals in one graph without pivoting data?

    Ben Perlman

      I have 4 measures that are a total of minutes, and then 4 calcs that are a percentage of each of those minutes.  What I would like to create it a bar graph with one bar being the percentages of the total by day:

       

       

      The only way I've found to do this is to first pivot the 4 % fields and then create the graph.  I'm afraid that this is a very large data set and multiplying the number of rows x4 will drastically decrease performance so want to see if there is another way to go about this.  Attached the workbook as an example with the data pivoted, and another workbook with the unpivoted data