0 Replies Latest reply: Sep 19, 2017 11:54 PM by Chrissy Brown RSS

    How to get the average rating from multiple columns created from avg expression in pivot table

    Chrissy Brown



      I have x10 columns in a pivot table. These columns display the average rating, by sales person, of all results from answered surveys. I have used the default expression Avg(FieldName) to get the average for each of these columns - which gives me the same results as my pivot table.


      I now need to get the average rating, by sales person, from the x10 already averaged columns.

      The field names are:



      I've tried reading all the documentation, but unfortunately I don't understand all the expression syntax. I'm hoping that one day (soon!) it will suddenly make sense I will be able to create all the required reports.


      In the meantime, many thanks in advance for any help you're able to give me.