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

# Multiple averages in one sheet

Hello,

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?

• ###### 1. Re: Multiple averages in one sheet

Christoph, you should be able to select the detail level of the "Average" reference line in the reference line dialog box.  Under the "Scope" section, try changing the radio button selection to "Per Pane" or "Per Cell" and see what happens.

• ###### 2. Re: Multiple averages in one sheet

Good morning

see the attached superstore example

it returns this

I needed to use the lod to get the average by product - I through in year just in case you want to look at multiple years

then used what was suggested above to put on a ref line (or avg line)

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 3. Re: Multiple averages in one sheet

Changing the scope has no effect on the line that is drawn.

• ###### 4. Re: Multiple averages in one sheet

Hello Jim,

I changed my calculation and the reference line according to your example. I only receive one plot in my diagram. In your example you are using a bar chart, I am using the shape type. May this be the problem?

• ###### 5. Re: Multiple averages in one sheet

hi this is what I get when I go to shape

Please post your twbx workbook so we can see what is going on- Guessing at a solution is not veryn productive

Jim

• ###### 6. Re: Multiple averages in one sheet

I change your workbook to the selection I have in my original workbook.

The average will be calculated per point, but I want a line for each selected product, as shown in the image below.