2 Replies Latest reply on Sep 4, 2017 10:00 AM by Daria Voronova

    Cannot mix aggregate and non-aggregate arguments to function

    Daria Voronova

      Hi, everyone!


      I am struggling with attempts to summarize specific data in one field.

      Literally, I need to know sum or total for specific rows in one column. And this summarize results should be calculated using COUNTD. Then I need to know the % of total.

      Any ideas, how I can handle the problem with calculating aggr and non-aggr functions?My sample data are in attached excel file, as well as explanation of task.

       

      Many thanks!