5 Replies Latest reply on Jul 27, 2016 5:15 PM by Kris Hallis

    Grand Total for row

    Kris Hallis


      I am putting together a Track and Field workbook.

      One of the sheets is designed to calculate the number of points achieved by each school in each event, and then display the total at the end of each row.

      I tried using Tableau's inbuilt 'Grand Total' function, but this does not work. I did read up on why this is the case, but cannot get my head around how to get around it.

      I've also tried lots of different solutions involving calculated fields (LoD, Window_sum) but have had no luck so far.

      I have attached a sample workbook, with a sheet called 'Points Prediction'. I want to  display the total points for each row (so 'A School' should be 30).

      I would appreciate any help.

      Thank you very much.