Hi...I have an issue with a pivot table where by I want to show an average of the data where one name comes up multiple times....I only want one average for all the data with the same name.
Hi...I have an issue with a pivot table where by I want to show an average of the data where one name comes up multiple times....I only want one average for all the data with the same name.
Hello NoobLearner and Welcome to Excel Forum.
Attached is my interpretation of what you want. If this doesn't represent the solution you are seeking, then I suggest uploading a spreadsheet with some sample data that is representative of the actual data and then manually mock up the output you would like the pivot table to display.
To upload a spreadsheet (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks