hello guys.
I need your help. we are grading our vendor and what i want to happen is how do i set up the table or pivot it.
we have 9 vendors - 30 users who will grade it- 9 module - 4 specific items for grading.
what i want to happen is for example im looking at the highest rating for that module i want to know specifically what vendor and the person who rate it.
attach here an example.
Hi EmilVictor,
Looking at the subject & the name of the file, I infer you are looking for best arrangement of the Pivot table, from the data in the file.
First, you need to generate the data. This can be generated as per attached file. (This particular format of data generation, I call it as 'inflating' the data). Basically, you are covering all users & vendors on the same page of the data (i.e. within the same data table)
Now, once you're through with inflating the data, you can use Pivot table (I certainly presume, you know it already) & then once you do that, there're tons of ways you can arrange & analyse it. Pl see the link for downloading the sample file (the attachment option doesn't work in MS Edge...)
PIVOT-updated.xlsx
Hope it works for you.
As I learn more,I learn there's even more to learn
I changed the format of your data.
after that i made a pivot table.
3xe1 I posted this with MS edge !
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi oeldere,
.. there must some issue with my MS Edge then.. not sure!
Regarding the topic, I think your file (the data part, 'sheet 2') is not covering all combinations.. for example, What is John's score for HRIS of Vendor 3? or Anna's score for Recruitment of Vendor 9? Consequently, the Pivot table, though looks compact & neat, is missing on lots of analysable data...
..any thoughts?
@3xe1
That is because they are not selected in the pivot table (of course they can also be selected).
Pivot tables can definitely help you make decisions of this type.
I created a pivot table with a calculated field to total the scores for each vendor from all the reviewers (I only did 2 reviewers but it shows the idea). Each vendor is rated by each reviewer and the scores totaled by viewer as a subtotal. At the bottom of the vendor (all reviewers) is the sum total for the vendor.
By using the MODULE Filter, you can quickly compare each vendor according to the module chosen without having the distraction of seeing the other modules.
You can have many different presentations by moving the fields around in the field list.
To show the results in the order of Total Scores click on the Grand total and then click on the Options tab and sort top to bottom Largest to smallest and that will order the vendors by their scores best to worst.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
@oeldere
No problems.. as long as the original poster finds it helpful.
cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks