1 Reply Latest reply on Jun 27, 2013 11:41 AM by Shawn Wallwork

    How do I average across rows and only show that average?

    Matt Gurren

      I am looking at data from a static perspective and I have a columns for dates and rows is how the old the user is. I only want to display the average. Example below:

       

      Row Labels6-May-137-May-138-May-139-May-1310-May-1311-May-1312-May-1313-May-1314-May-1315-May-13Average Across
      0100%100%100%100%100%100%100%100%100%100%100%
      152%52%51%50%46%52%51%51%51%50%51%
      241%41%39%33%36%40%39%40%39%37%38%
      335%34%29%29%37%34%34%34%32%28%33%
      431%26%27%34%32%31%31%29%25%26%29%
      524%25%31%31%30%28%27%23%23%29%27%
      623%29%28%28%27%26%26%22%27%27%26%
      727%27%26%26%24%25%26%26%25%26%26%
      825%25%24%23%20%24%23%24%23%23%23%
      923%23%21%18%19%22%21%22%21%20%21%
      1022%21%18%18%21%21%20%21%19%16%20%
      1119%17%17%21%20%20%19%18%15%15%18%
      1216%17%20%20%19%19%18%15%14%16%17%
      1316%20%19%19%18%18%17%14%15%18%17%
      1419%20%18%19%17%17%17%15%18%18%18%
      1518%18%17%17%14%16%17%18%17%17%17%
      1617%17%15%13%13%17%16%17%16%15%16%
      1716%15%12%12%14%16%16%16%15%13%15%
      1815%12%12%13%15%15%15%15%12%13%14%
      1912%12%13%16%15%15%14%12%12%15%14%
      2011%13%15%15%15%14%13%12%14%14%14%