I need to calculate the average of the values in the right column, this is a pivot table (IMG1). I can't find a way to do this, also using "Totals and aggregation", and COUNT (DISTINCT ) function to count how many different values are there in the row on the left (as the Pivot Table does) and then divide that number for the sum of the values in the right column is not feasible, because the (DISTINCT) part of the function behaves in a strange way: when I verify it it says "valid function"(IMG2), but then when I load the data page, i get the message "Error in formula" instead of the datas
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Alessandro
I need to calculate the average of the values in the right column, this is a pivot table (IMG1). I can't find a way to do this, also using "Totals and aggregation", and COUNT (DISTINCT ) function to count how many different values are there in the row on the left (as the Pivot Table does) and then divide that number for the sum of the values in the right column is not feasible, because the (DISTINCT) part of the function behaves in a strange way: when I verify it it says "valid function"(IMG2), but then when I load the data page, i get the message "Error in formula" instead of the datas
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.