7 Replies Latest reply on Feb 25, 2017 9:54 AM by Ben Walsh

    Calculated Fields

    Ben Walsh

      Hi,

      I have a basic question around applying a calculated field to all rows.

       

      I want to group rows (by country), calculate the Average for one Country (Ireland) and then deduct this average from all countries. The issue is that since the average is only calculated for one country then the column "Total Minus Avg" column is missing values for the other countries as below.I understand this is because the table calculations are done across. I just don't know what the best solution would be.

       

      CountrySalesAvgTotal minus Avg
      Ireland1000200800
      England500
      France400

       

      The ultimate goal is to create a bar chart and use the value "Total minus Avg" as my X axis to show countries above and below this line( as per sheet 3). I thought by creating calculated fields this may be the best solution but perhaps there is a better way.

       

      Many thanks,

      Ben