3 Replies Latest reply on Aug 15, 2018 11:54 AM by Ty Adams

    Rollup problems with averages

    Ty Adams

      I need some help. I am trying to show on one line the average of a group but it is not rolling up correctly

       

      below is the problem

      If you take the average of the individual lines you should get 240.6 for "2a" and 1235.33 for "3" which is what i want to show.

       

      When I remove SCD ID I get 253 and 1452.  How can I get rollup to the average of the individual SCD ID's without showing the SCD ID's

       

      This is what the report needs to look like (copying a report in an old legacy system to Tableau). Any help would be great.