6 Replies Latest reply on Jul 2, 2018 1:32 AM by christoph.kreibich.0

    Multiple averages in one sheet




      I have a sheet where multiple products are displayed. I used a different color for each product. The products, that are displayed, can be selected with dropdown list. Now I want to add an average per product. So that there is a line for the average of product A and a line for the average of product B and so on.

      I created a calculated field that is calculating the average per product. When inserting a reference line I can select the calculated field but I will only have one average for all products shown. How can I display multiple lines for the averages of each product?